On Friday, March 28, 2003, at 12:57 AM, Foong wrote:
sorry typo error should be:
date('Y')
Foong
"Foong" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]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
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
