The following is examples of SQL avaiable in MySQL and MariaDB
# 1 month ago
NOW() - INTERVAL 1 MONTH
# 3 months and 7 days ago
NOW() - INTERVAL 3 MONTH -INTERVAL 7 DAY
# Specify hour, minute, second
DATE_FORMAT(now() - interval 1 year - interval 3 month, '%Y-%m-%d')
Subscribe to:
Post Comments (Atom)
-
What is partitioning? The structure which divides one table data to multiple data. When not using partitioning, one table data is aggrega...
-
It is general to create multiple branches and manage them parallel when we do the development by using git. Multiple branches should be mer... -
What's URL encode? URL can be sent only ASCII characters over internet. When doing http request with query parameters, query parameter...
No comments:
Post a Comment