Showing date/time columns in timezone

[dbinott]

I store all date/times as UTC and was wondering if there is a way to show them in a certain timezone w/o building a query? Just like you can format the date/time output.

[alexa]

In MySQL, there are no data types storing the information about time zones unlike Oracle having timestamp with timezone or MS SQL Server with datetimeoffset. Please also see https://dev.mysql.com/doc/refman/5.5/en/datetime.html

[dbinott]

no, i was just hoping i could apply a function before the data is output in studio.

[alexa]

Thank you for the reply.

You can add a suggestion on our UserVoice forum where other users can vote for it http://devart.uservoice.com/forums/7729 ... -for-mysql

We collect and analyze the information from this forum in order to make a proper roadmap for future product releases.