YanoRyuichi.com/
Wiki
Blog
GitHub
Sandbox
開始行:
* 日付の切り捨て・切り上げ [#z68d8c97]
** DATE()を使う方法 [#ub18f9aa]
mysql> SELECT DATE(NOW());
+-------------+
| DATE(NOW()) |
+-------------+
| 2019-06-07 |
+-------------+
** DATE_FORMAT()を使う方法 [#jcedcc9a]
mysql> SELECT DATE_FORMAT(NOW(), ' %Y-%m-01');
+--------------------------------+
| DATE_FORMAT(NOW(), '%Y-%m-01') |
+--------------------------------+
| 2019-06-01 |
+--------------------------------+
** 参考 [#leb4659b]
- https://dev.mysql.com/doc/refman/8.0/en/date-and-time-f...
終了行:
* 日付の切り捨て・切り上げ [#z68d8c97]
** DATE()を使う方法 [#ub18f9aa]
mysql> SELECT DATE(NOW());
+-------------+
| DATE(NOW()) |
+-------------+
| 2019-06-07 |
+-------------+
** DATE_FORMAT()を使う方法 [#jcedcc9a]
mysql> SELECT DATE_FORMAT(NOW(), ' %Y-%m-01');
+--------------------------------+
| DATE_FORMAT(NOW(), '%Y-%m-01') |
+--------------------------------+
| 2019-06-01 |
+--------------------------------+
** 参考 [#leb4659b]
- https://dev.mysql.com/doc/refman/8.0/en/date-and-time-f...
ページ名:
