1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
| select now(), timestampadd(day, 10, now());
select now(), timestampadd(SQL_TSI_DAY, 10, now());
select now(), timestampadd(hour, 10, now());
select now(), timestampadd(SQL_TSI_HOUR, 10, now());
select now(), timestampadd(minute, 10, now());
select now(), timestampadd(second, 10, now());
select now(), timestampadd(microsecond, 10, now());
select now(), timestampadd(day, -10, now());
select now(), timestampadd(hour, -10, now());
select timestampadd(year, 10, '');
select timestampadd(year, 10000, now());
select timestampadd(second, null, now());
select timestampadd(second, 10, null);
|
