edsel99

I guess I don't understand why it's adjusting the time anyway. I have a date time value in the database (i.e. 5/25/2005 6:45 PM). I request that field from the database and ask the php script to print it on the page. I don't understand why it is taking that date and adding an hour. If I add in the Eastern - EST5EDT when looking at gametimes from last winter will those now be an hour off? I guess I will add it and see. Thanks Eric

I keep my Volleyball schedule on my website. I use PHP Scripts to retrieve the game time from the MySQL database. Everything was working great until just recently and I noticed all of the times were an hour off. For example the real game time that is entered into the database is 6:45 PM. When I look at my website it is displaying 7:45 PM. This has been working since November and just recently stopped. My only guess is that it has something to do with Daylight savings. I am using the UNIX_TIMESTAMP() in my SQL statement and date("M j",$gamedate) in my PHP script. Any help on how to fix this problem would be appreciated. Other wise I will be forced to adjust in the script for DST. If this is my only options what dates are the breaking points for DST. Eric Grinnell http://www.peakfinder.net