Timezone suggestions

[djones]

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.

[djones]

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

[fenway]

Well, then you'll have to debug each part of that expression.