In two words - here's your bible, Erik:
http://www.mysql.org/documentation/mysql/bychapter/manual_Reference.html #Date_and_time_functions Sincerely, Maxim Maletsky Founder, Chief Developer PHPBeginner.com (Where PHP Begins) www.phpbeginner.com [EMAIL PROTECTED] > -----Original Message----- > From: Erik Price [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 03, 2002 11:27 PM > To: Rasmus Lerdorf > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP] 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 > [EMAIL PROTECTED] > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
