On Wednesday, April 3, 2002, at 03:58  PM, Miguel Cruz wrote:

> On Wed, 3 Apr 2002, Rick Emery wrote:
>> Convert to date/time variable and perform arithmetic.
>> Otherwise, if these dates are from mysql, let mysql do it
> 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.



Erik Price
Web Developer Temp
Media Lab, H.H. Brown

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

Reply via email to