Skip to content

Instantly share code, notes, and snippets.

@J2112O

J2112O/mysql_date.sql

Created June 9, 2022 00:51
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 J2112O/1fdf6acbcce2f45e0b96233d7b7b9153 to your computer and use it in GitHub Desktop.
Save J2112O/1fdf6acbcce2f45e0b96233d7b7b9153 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql_date.sql
mysql> SELECT last_update, DATE(last_update)
-> FROM category
-> LIMIT 5;
+---------------------+-------------------+
| last_update | DATE(last_update) |
+---------------------+-------------------+
| 2006-02-15 04:46:27 | 2006-02-15 |
| 2006-02-15 04:46:27 | 2006-02-15 |
| 2006-02-15 04:46:27 | 2006-02-15 |
| 2006-02-15 04:46:27 | 2006-02-15 |
| 2006-02-15 04:46:27 | 2006-02-15 |
+---------------------+-------------------+
5 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment