DURATION

A time period in milliseconds.

Converting to DURATION

1
2
DURATION(milliseconds)
DURATION(TIMESTAMP1 - TIMESTAMP2)
  1. converts a milliseconds value to DURATION
  2. converts a period between TIMESTAMP1 and TIMESTAMP2 to DURATION

Example:

1
select(DURATION(1000*60*60*24*30));
duration
30 days, 00:00:00.000