我正在开发一个只能在以色列中运行的应用。 我们所有的表格都包含以色列时间的时间（<特拉维夫时间）。 >在 GCP 中不支持默认的时区和时区转换我被卡住了。 时区之间的时间？
让我提醒您，以色列的节省时间。
现在您可以在Cloud SQL中设置时区了。请参阅 cloud.google/sql/docs/mysql-flags。限制是需要将时区指定为UTC的偏移量，例如'+10：00'。它不支持像欧洲/赫尔辛基这样的命名时区。
I'm developing an app that meant to run only in Israel. All of our tables contains times at Israeli time (Tel Aviv time).
because the SQL in GCP doesn't support default timezone and time zone convert I got stuck.
how can I convert times between time zones?
let me remind you that Israel has a light saving time change.
解决方案Now you have the ability to set the time zone in Cloud SQL. See cloud.google/sql/docs/mysql-flags. The limitation is that the time zone needs to be specified as offsets to UTC, such as '+10:00'. It does not support named time zones like 'Europe/Helsinki'.
更多推荐
Google Cloud SQL和时区
发布评论