On Wed, 3 Apr 2002, Erik Price wrote:
> On Wednesday, April 3, 2002, at 03:58  PM, Miguel Cruz wrote:
>> Even if you don't happen to be getting the date out of MySQL,
>> it can occasionally be easier to let MySQL do your date math since
>> it has some nice functions for it (DATE_ADD, DATE_SUB, etc.). These
>> things are hard to do quickly in PHP since you have to account for leap
>> years.
> I'd actually like to use MySQL's builtin date formats, but I like the 
> timestamp that PHP uses (and I like what I can do with a timestamp in 
> the date() function) so I have been using VARCHAR(20) to hold the date 
> as a string.  MySQL's TIMESTAMP is not the same thing as PHP's.

You can also convert back and forth between UNIX_TIMESTAMP and MySQL's
native timestamp format as you please.


PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to