Skip to content

Instantly share code, notes, and snippets.

@kevinmichaelchen

kevinmichaelchen/utc-timezone-mysql.md

Forked from dotspencer/utc-timezone-mysql.md
Last active June 15, 2018 17:21
Download ZIP

Revisions

  1. kevinmichaelchen revised this gist Jun 15, 2018. 1 changed file with 10 additions and 1 deletion.
    11 changes: 10 additions & 1 deletion utc-timezone-mysql.md
    View file
    Original file line number Diff line number Diff line change
    @@ -4,4 +4,13 @@ Add the following below `[mysqld]`

    default-time-zone='+00:00'

    Restart mysql with `brew services restart mysql`
    Restart mysql with `brew services restart mysql`

    ```
    mysql> SELECT @@system_time_zone, @@global.time_zone, @@session.time_zone;
    +--------------------+--------------------+---------------------+
    | @@system_time_zone | @@global.time_zone | @@session.time_zone |
    +--------------------+--------------------+---------------------+
    | EDT | +00:00 | +00:00 |
    +--------------------+--------------------+---------------------+
    ```
  2. @dotspencer dotspencer revised this gist Dec 1, 2017. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion utc-timezone-mysql.md
    View file
    Original file line number Diff line number Diff line change
    @@ -1,4 +1,4 @@
    Edit /usr/local/etc/my.cnf
    Edit `/usr/local/etc/my.cnf`

    Add the following below `[mysqld]`

  3. @dotspencer dotspencer revised this gist Dec 1, 2017. 1 changed file with 3 additions and 1 deletion.
    4 changes: 3 additions & 1 deletion utc-timezone-mysql.md
    View file
    Original file line number Diff line number Diff line change
    @@ -2,4 +2,6 @@ Edit /usr/local/etc/my.cnf

    Add the following below `[mysqld]`

    default-time-zone='+00:00'
    default-time-zone='+00:00'

    Restart mysql with `brew services restart mysql`
  4. @dotspencer dotspencer created this gist Dec 1, 2017.
    5 changes: 5 additions & 0 deletions utc-timezone-mysql.md
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,5 @@
    Edit /usr/local/etc/my.cnf

    Add the following below `[mysqld]`

    default-time-zone='+00:00'