daylight savings time
| From: | bill | Date: | Fri, 30 Mar 2001 20:56:04 +0000 |
| Subject: | daylight savings time | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-46383@lists.php.net to get a copy of this message | ||
How can I get my PHP/MySQL to recognize dates that are on daylight
savings time?
I have a mysql table with a date field (today would be 2001-03-30).
I convert a date into a unix timetamp using
$thisdaysec=mktime($somedate);
Then, to find a particular date in the database I run a query:
SELECT name FROM my_database
WHERE UNIX_TIMESTAMP(date) = $thisdaysec
Unfortunately, this code, which used to work fine, begins to fail when
looking for dates after this weekend. The two unix timestamps are
exactly one hour off. Daylight savings time?
I appreciate any help.
kind regards,
bill hollett