Interval Functions This section provides reference information for the interval functions in TiDB Cloud Lake. Interval functions allow you to create interval values of various time units for use in date and time calculations.
Time Unit Conversion Functions Day-based Intervals Function Description Example TO_DAYS Converts a number to an interval of days TO_DAYS(2) → 2 daysTO_WEEKS Converts a number to an interval of weeks TO_WEEKS(3) → 21 daysTO_MONTHS Converts a number to an interval of months TO_MONTHS(2) → 2 monthsTO_YEARS Converts a number to an interval of years TO_YEARS(1) → 1 year
Hour-based Intervals Function Description Example TO_HOURS Converts a number to an interval of hours TO_HOURS(5) → 5:00:00TO_MINUTES Converts a number to an interval of minutes TO_MINUTES(90) → 1:30:00TO_SECONDS Converts a number to an interval of seconds TO_SECONDS(3600) → 1:00:00EPOCH Alias for TO_SECONDS EPOCH(60) → 00:01:00
Smaller Time Units Function Description Example TO_MILLISECONDS Converts a number to an interval of milliseconds TO_MILLISECONDS(2000) → 00:00:02TO_MICROSECONDS Converts a number to an interval of microseconds TO_MICROSECONDS(2000000) → 00:00:02
Larger Time Units Function Description Example TO_DECADES Converts a number to an interval of decades TO_DECADES(2) → 20 yearsTO_CENTRIES Converts a number to an interval of centuries TO_CENTRIES(1) → 100 yearsTO_MILLENNIA Converts a number to an interval of millennia TO_MILLENNIA(1) → 1000 years