Time Select Statement EDT, not PDT

[wreed]

My webserver is in Pacific Daylight Time....I want it to display in Eastern Daylight time, Can I do this in my select statement?

Here it is...

SELECT DATE_FORMAT( ts,  '%b %D, %Y, %l:%i%p'  )  AS date, game FROM schedule WHERE winloss <>  'null' ORDER  BY game DESC LIMIT 1

[wreed]

Hey guys I found a great post on DevShed that told me how to do this, so for anyone who need this, here it is.

SELECT DATE_FORMAT(INTERVAL 3 HOUR + ts, '%b %D, %Y, %l:%i%p' ) AS date, game FROM schedule WHERE winloss <> 'null' ORDER BY game DESC LIMIT 1