Devart Forums

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.

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

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

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.