djones Posted January 10, 2010 Share Posted January 10, 2010 I live in EST US. My server is in Central US. Which is the better way to display the date/time for my time zone. Should I convert it going into the database via INSERT, or convert it during the SELECT query? I will eventually have users that will set their own time zones. Any insight would be greatly appreciated. Link to comment https://forums.phpfreaks.com/topic/187973-timezone-suggestions/ Share on other sites More sharing options...
djones Posted January 10, 2010 Author Share Posted January 10, 2010 On that note... When I run this query: SELECT DATE_FORMAT(CONVERT_TZ(p.page_date, 'CST', 'EST'), '%M %d, %Y at %h:%i %p') AS f_date FROM tablename f_date is returning NULL Link to comment https://forums.phpfreaks.com/topic/187973-timezone-suggestions/#findComment-992443 Share on other sites More sharing options...
fenway Posted January 13, 2010 Share Posted January 13, 2010 Well, then you'll have to debug each part of that expression. Link to comment https://forums.phpfreaks.com/topic/187973-timezone-suggestions/#findComment-994370 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.