Skip to content

Instantly share code, notes, and snippets.

@eiryu

eiryu/a.sql

Created October 30, 2018 12:55
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save eiryu/cc881447f09c2f537d8745b144da36ce to your computer and use it in GitHub Desktop.
Save eiryu/cc881447f09c2f537d8745b144da36ce to your computer and use it in GitHub Desktop.
Download ZIP
MySQLでtimestampをdateに変換する
Raw
a.sql
mysql> select date_format(now(), '%Y-%m-%d');
+--------------------------------+
| date_format(now(), '%Y-%m-%d') |
+--------------------------------+
| 2018-10-30 |
+--------------------------------+
1 row in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment