Hello Jough,
Thursday, December 4, 2003, 6:39:13 PM, you wrote:
JJ> Greetings all, I'm working on a message-board-type
JJ> application that will use time stamps to sort part of the
JJ> messages. I was wondering what everyone's favorite way to
JJ> transfer dates between PHP and MySQL was?
Seeing as MySQL will only take them in one standard format you have to
adhere to that ('YYYY-MM-DD HH:MM:SS'). All the MySQL date operations
work on this format, so keep to it. When you pass from PHP to MySQL,
make sure it's in that format (easy to do with the date() function).
If you need to convert more esoteric formats, or do date handling from
within PHP before sending to MySQL then use the strtotime function
combined with the date().
Unless you meant something else of course? :)
--
Best regards,
Richard mailto:[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
