Datetime and Interval Data Types

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

The datetime data types are DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, and TIMESTAMP WITH LOCAL TIME ZONE. Values of datetime data types are sometimes called datetimes. The interval data types are INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND. Values of interval data types are sometimes called intervals. (Oracle SQL Language Reference Datetime and Interval Data Types)

Here are the articles in this section:

DATE Data TypeTIMESTAMP Data TypeTIMESTAMP WITH TIME ZONE Data TypeTIMESTAMP WITH LOCAL TIME ZONE Data TypeINTERVAL DAY TO SECOND Data TypeINTERVAL YEAR TO MONTH Data TypeDatetime Arithmetic