hi, $start = mktime ( 0, 0, 0, 1, 1, date['Y']); // first day of this year $end = mktime ( 0, 0, 0, 12, 31, date['Y']); // last day of this year
then select all record where timestamp >= $start and timestamp <= $end should do the job Hope this helps Foong "Charles Kline" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Okay cool. > > This leads me to another question. If I have stored the date as an > epoch then is there a way using PHP and MySQL to say find all the > records that have been added this YEAR (not last 365 days)? > > Thanks > Charles > > > On Friday, March 28, 2003, at 12:31 AM, Leo Spalteholz wrote: > > > On March 27, 2003 09:15 pm, Charles Kline wrote: > >> I am storing my dates as unix timestamp (epoch). Am I right in > >> assuming that if I need to add or subtract days from this it is > >> done in seconds? > > > > yes > > > > > > -- > > 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
