sql date_sub 和 date_add

biqguery

SELECT
  TIME "15:30:00" as original_time,
  TIME_ADD(TIME "15:30:00", INTERVAL 10 MINUTE) as later;

original_time	later
15:30:00	15:40:00

SELECT   "2020-08-08 15:30:00" as original_time,   date_ADD( "2020-08-08 15:30:00", INTERVAL 10 day) as later;

mysql

original_time	later
2020-08-08 15:30:00	2020-08-18 15:30:00

biqguery

SELECT
  TIME "15:30:00" as original_date,
  TIME_SUB(TIME "15:30:00", INTERVAL 10 MINUTE) as earlier;

original_date	earlier
15:30:00	15:20:00

SELECT   "2020-08-08 15:30:00" as original_time,   date_sub( "2020-08-08 15:30:00", INTERVAL 10 day) as before1;

mysql

original_time	before1
2020-08-08 15:30:00	2020-07-29 15:30:00