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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
