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. Quote 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 Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/187973-timezone-suggestions/#findComment-994370 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.