https://community.databricks.com/t5/data-engineering/is-there-a-interval-data-type/m-p/104538#M41786 <P>Hi&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/133094">@jeremy98</a>,</P> <P>You can use the <CODE>TIMESTAMP</CODE> and <CODE>TIMESTAMP_NTZ</CODE> data types to handle date and time values, similar to the <CODE>DATETIME</CODE> type in PostgreSQL. However, Databricks does not have a direct equivalent to PostgreSQL's <CODE>TIMEDELTA</CODE> type</P> <P><A href="https://docs.databricks.com/ja/sql/language-manual/sql-ref-datatypes.html" target="_blank">https://docs.databricks.com/ja/sql/language-manual/sql-ref-datatypes.html</A></P> Tue, 07 Jan 2025 15:10:50 GMT Alberto_Umana 2025-01-07T15:10:50Z https://community.databricks.com/t5/data-engineering/is-there-a-interval-data-type/m-p/104537#M41785 <P>Hi community,<BR />I was using a column in postgresSQL that is a DATETIME.TIMEDELTA, is it possible to have the same data type also in Databricks?</P> Tue, 07 Jan 2025 15:08:01 GMT https://community.databricks.com/t5/data-engineering/is-there-a-interval-data-type/m-p/104537#M41785 jeremy98 2025-01-07T15:08:01Z https://community.databricks.com/t5/data-engineering/is-there-a-interval-data-type/m-p/104538#M41786 <P>Hi&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/133094">@jeremy98</a>,</P> <P>You can use the <CODE>TIMESTAMP</CODE> and <CODE>TIMESTAMP_NTZ</CODE> data types to handle date and time values, similar to the <CODE>DATETIME</CODE> type in PostgreSQL. However, Databricks does not have a direct equivalent to PostgreSQL's <CODE>TIMEDELTA</CODE> type</P> <P><A href="https://docs.databricks.com/ja/sql/language-manual/sql-ref-datatypes.html" target="_blank">https://docs.databricks.com/ja/sql/language-manual/sql-ref-datatypes.html</A></P> Tue, 07 Jan 2025 15:10:50 GMT https://community.databricks.com/t5/data-engineering/is-there-a-interval-data-type/m-p/104538#M41786 Alberto_Umana 2025-01-07T15:10:50Z