SQLで日付の計算
日付を加算・減産
NOW() - INTERVAL 60 SECOND 単位
- MICROSECOND
- SECOND
- MINUTE
- HOUR
- DAY
- WEEK
- MONTH
ゼロ時から検索したい
DATE_FORMAT(NOW() - INTERVAL 60 DAY, '%Y-%m-%d 00:00:00' ) This post is licensed under CC BY 4.0 by the author.
NOW() - INTERVAL 60 SECOND DATE_FORMAT(NOW() - INTERVAL 60 DAY, '%Y-%m-%d 00:00:00' )