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


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


Sorry, only registered users may post in this forum.

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.