select now(),date_add(now() ,interval 1 day),adddate(now() ,interval 12 year),adddate(now(),10000);
select now(),date_add(now() ,interval 1 second),now()+interval 1 day;
gbase> select timestampdiff(year,current_timestamp,timestamp'2020-12-31 10:10:10');
+----------------------------------------------------------------------+
| timestampdiff(year,current_timestamp,timestamp'2020-12-31 10:10:10') |
+----------------------------------------------------------------------+
| 0 |
+----------------------------------------------------------------------+
1 row in set (Elapsed: 00:00:00.00)
gbase> select timestampdiff(month,current_timestamp,timestamp'2020-12-31 10:10:10');
+-----------------------------------------------------------------------+
| timestampdiff(month,current_timestamp,timestamp'2020-12-31 10:10:10') |
+-----------------------------------------------------------------------+
| -9 |
+-----------------------------------------------------------------------+
1 row in set (Elapsed: 00:00:00.00)
gbase> select timestampdiff(month,timestamp'2020-12-31 10:10:10',current_timestamp);
+-----------------------------------------------------------------------+
| timestampdiff(month,timestamp'2020-12-31 10:10:10',current_timestamp) |
+-----------------------------------------------------------------------+
| 9 |
+-----------------------------------------------------------------------+
1 row in set (Elapsed: 00:00:00.00)
gbase> select timestampdiff(year,timestamp'2020-12-31 10:10:10',current_timestamp);
+----------------------------------------------------------------------+
| timestampdiff(year,timestamp'2020-12-31 10:10:10',current_timestamp) |
+----------------------------------------------------------------------+
| 0 |
+----------------------------------------------------------------------+
1 row in set (Elapsed: 00:00:00.00)
gbase> select timestampdiff(day,timestamp'2020-12-31 10:10:10',current_timestamp);
+---------------------------------------------------------------------+
| timestampdiff(day,timestamp'2020-12-31 10:10:10',current_timestamp) |
+---------------------------------------------------------------------+
| 286 |
+---------------------------------------------------------------------+
1 row in set (Elapsed: 00:00:00.00)
gbase> select timestampdiff(week,timestamp'2020-12-31 10:10:10',current_timestamp);
+----------------------------------------------------------------------+
| timestampdiff(week,timestamp'2020-12-31 10:10:10',current_timestamp) |
+----------------------------------------------------------------------+
| 40 |
+----------------------------------------------------------------------+
1 row in set (Elapsed: 00:00:00.00)
gbase> select timestampdiff(month,timestamp'2020-12-31 10:10:10',current_timestamp);
+-----------------------------------------------------------------------+
| timestampdiff(month,timestamp'2020-12-31 10:10:10',current_timestamp) |
+-----------------------------------------------------------------------+
| 9 |
+-----------------------------------------------------------------------+
1 row in set (Elapsed: 00:00:00.00)
gbase> select timestampdiff(second,timestamp'2020-12-31 10:10:10',current_timestamp);
+------------------------------------------------------------------------+
| timestampdiff(second,timestamp'2020-12-31 10:10:10',current_timestamp) |
+------------------------------------------------------------------------+
| 24750896 |
+------------------------------------------------------------------------+
1 row in set (Elapsed: 00:00:00.00)
gbase> select timestampdiff(minute,timestamp'2020-12-31 10:10:10',current_timestamp);
+------------------------------------------------------------------------+
| timestampdiff(minute,timestamp'2020-12-31 10:10:10',current_timestamp) |
+------------------------------------------------------------------------+
| 412515 |
+------------------------------------------------------------------------+
1 row in set (Elapsed: 00:00:00.00)
gbase> select timestampdiff(hour,timestamp'2020-12-31 10:10:10',current_timestamp);
+----------------------------------------------------------------------+
| timestampdiff(hour,timestamp'2020-12-31 10:10:10',current_timestamp) |
+----------------------------------------------------------------------+
| 6875 |
+----------------------------------------------------------------------+
1 row in set (Elapsed: 00:00:00.00)
