| 14.12.DATE_SUB |
| 14.12.1. | DATE_SUB(date,INTERVAL expr unit) |
| 14.12.2. | DATE_SUB(curdate(), INTERVAL 1 MICROSECOND); |
| 14.12.3. | DATE_SUB(curdate(), INTERVAL 1 MINUTE); |
| 14.12.4. | DATE_SUB(curdate(), INTERVAL 1 HOUR); |
| 14.12.5. | DATE_SUB(curdate(), INTERVAL 1 DAY); |
| 14.12.6. | DATE_SUB(curdate(), INTERVAL 1 WEEK); |
| 14.12.7. | DATE_SUB(curdate(), INTERVAL 1 MONTH); |
| 14.12.8. | DATE_SUB(curdate(), INTERVAL 1 QUARTER); |
| 14.12.9. | DATE_SUB(curdate(), INTERVAL 1 YEAR); |
|
| 14.12.10. | DATE_SUB(curdate(), INTERVAL 1.1 SECOND_MICROSECOND); |
| 14.12.11. | DATE_SUB(curdate(), INTERVAL 1 SECOND); |
| 14.12.12. | DATE_SUB(curdate(), INTERVAL 1.1 SECOND); |
| 14.12.13. | DATE_SUB(curdate(), INTERVAL 1.1 MINUTE_MICROSECOND); |
| 14.12.14. | DATE_SUB(curdate(), INTERVAL 1.1 MINUTE_SECOND); |
| 14.12.15. | select DATE_SUB(curdate(), INTERVAL 1.1 HOUR_MICROSECOND); |
| 14.12.16. | select DATE_SUB(curdate(), INTERVAL 1.1 HOUR_SECOND); |
| 14.12.17. | select DATE_SUB(curdate(), INTERVAL '1:1:1' HOUR_SECOND); |
| 14.12.18. | select DATE_SUB(curdate(), INTERVAL 1.1 HOUR_MINUTE); (with dot) |
| 14.12.19. | select DATE_SUB(curdate(), INTERVAL '1:1' HOUR_MINUTE); |
|
| 14.12.20. | select DATE_SUB(curdate(), INTERVAL 1.1 DAY_MICROSECOND); |
| 14.12.21. | select DATE_SUB(curdate(), INTERVAL '1 1:1:1' DAY_SECOND); |
| 14.12.22. | select DATE_SUB(curdate(), INTERVAL '1 1:1' DAY_MINUTE); |
| 14.12.23. | select DATE_SUB(curdate(), INTERVAL '1 1' DAY_HOUR); |
| 14.12.24. | select DATE_SUB(curdate(), INTERVAL 1.1 SECOND_MICROSECOND); |
| 14.12.25. | select DATE_SUB(curdate(), INTERVAL '1-1' YEAR_MONTH); |
| 14.12.26. | select DATE_SUB(curdate(), INTERVAL '1.1' YEAR_MONTH); (with dot) |
| 14.12.27. | Selects all rows with a start_date value from within the last 30 days |
| 14.12.28. | Getting a date 6 months in the past |
| 14.12.29. | Using DATE_SUB function to substract 55 years from current date |