MySQL Forums
Forum List  »  MySQL Workbench

Set default timezone for mysql client
Posted by: Salil Surendran
Date: September 22, 2017 11:31AM

I have a MySQL database that stores time in UTC. However, when I connect to it using MySQL Workbench I would like to see time in PST. I know I can use tz_convert to convert individual columns to PST. I was wondering is there any way I set the entire client session to a timezone so that I don't have to put tz_convert over every individual time columns.

Options: ReplyQuote

Written By
Set default timezone for mysql client
September 22, 2017 11:31AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.