Re: syntax for date math expressions

On Wednesday, April 3, 2002, at 04:14 PM, Rasmus Lerdorf wrote:

But you can simply call MySQL's UNIX_TIMESTAMP() function on the mysql field when you select it if you want it into unix timestamp format.

For SELECTs, this is fine, but what happens when I want to insert a new date? I transform all of my dates into Unix timestamps so that I can pass them around in form fields etc, but MySQL's timestamp format is different. Is there some way to call something like UNIX_TO_MYSQL_TIMESTAMP() in MySQL (or PHP)? Erik ---- Erik Price Web Developer Temp Media Lab, H.H. Brown pricee@hhbrown.com