Geek Answers Handbook

Change Google Cloud SQL timezone CURRENT_TIMESTAMP?

I use CURRENT_TIMESTAMPin Google Cloud SQL and according to Google , it returns the current server time.

Currently, since his return, he looks like a server at UTC -1 (i.e., in the Atlantic Ocean). This is not very helpful.

How do I change the time zone and display the right time (i.e. the time zone of my choice) when I call CURRENT_TIMESTAMP?

+4
source share
2 answers

There is a new way to change the time zone of Google Cloud SQL fooobar.com/questions/1561005 / ...

Instructions: https://cloud.google.com/sql/docs/mysql-flags

  • Google Developers Console.
  • .
  • "" > " SQL", Cloud SQL .
  • "". , .
  • " MySQL".
  • .
  • "". MySQL .
+4

Cloud SQL UTC.

:

SET @@session.time_zone='-07:00';

, , :

( ) , "/ ",
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -h YOUR_INSTANCE_IP -u root -p mysql
0

More articles:


All Articles