Interval Functions

This section provides reference information for the interval functions in PlaidCloud Lakehouse.


EPOCH

Learn how to use EPOCH in PlaidCloud Lakehouse. Alias for the TO_SECONDS interval function. Includes detailed syntax, examples, and usage reference.

TO_CENTURIES

Learn how to use the TO_CENTURIES interval function in PlaidCloud Lakehouse. Converts a specified number of centuries into an Interval type.

TO_DAYS

Learn how to use the TO_DAYS interval function in PlaidCloud Lakehouse. Converts a specified number of days into an Interval type. Includes syntax and examples.

TO_DECADES

Learn how to use the TO_DECADES interval function in PlaidCloud Lakehouse. Converts a specified number of decades into an Interval type. Includes syntax and...

TO_HOURS

Learn how to use the TO_HOURS interval function in PlaidCloud Lakehouse. Converts a specified number of hours into an Interval type. With syntax and examples.

TO_MICROSECONDS

Learn how to use the TO_MICROSECONDS interval function in PlaidCloud Lakehouse. Converts a specified number of microseconds into an Interval type.

TO_MILLENNIA

Learn how to use the TO_MILLENNIA interval function in PlaidCloud Lakehouse. Converts a specified number of millennia into an Interval type.

TO_MILLISECONDS

Learn how to use the TO_MILLISECONDS interval function in PlaidCloud Lakehouse. Converts a specified number of milliseconds into an Interval type.

TO_MINUTES

Learn how to use the TO_MINUTES interval function in PlaidCloud Lakehouse. Converts a specified number of minutes into an Interval type. Includes syntax and...

TO_MONTHS

Learn how to use the TO_MONTHS interval function in PlaidCloud Lakehouse. Converts a specified number of months into an Interval type. With syntax and examples.

TO_SECONDS

Learn how to use the TO_SECONDS interval function in PlaidCloud Lakehouse. Converts a specified number of seconds into an Interval type. Includes syntax and...

TO_WEEKS

Learn how to use the TO_WEEKS interval function in PlaidCloud Lakehouse. Converts a specified number of weeks into an Interval type. With syntax and examples.

TO_YEARS

Learn how to use the TO_YEARS interval function in PlaidCloud Lakehouse. Converts a specified number of years into an Interval type. With syntax and examples.