1. DATE_ADD()
Add a time to a specific date.
1
2
3
4
5
6
7
8
9
10
11
12
13
| DATE_ADD(date, INTERVAL expr type)
params:
expr: a number
type: time type,
- DAY
- WEEK
- MONTH
- YEAR
- SECOND
- MINUTE
- HOUR
- ...
|
example:
1
| DATE_ADD(cat.VALID_END_DATE, INTERVAL 1 DAY)
|