- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-07-2025 07:08 AM
Hi community,
I was using a column in postgresSQL that is a DATETIME.TIMEDELTA, is it possible to have the same data type also in Databricks?
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-07-2025 07:09 AM - edited 01-07-2025 07:10 AM
Hi @jeremy98,
You can use the TIMESTAMP
and TIMESTAMP_NTZ
data types to handle date and time values, similar to the DATETIME
type in PostgreSQL. However, Databricks does not have a direct equivalent to PostgreSQL's TIMEDELTA
type
https://docs.databricks.com/ja/sql/language-manual/sql-ref-datatypes.html
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-07-2025 07:09 AM - edited 01-07-2025 07:10 AM
Hi @jeremy98,
You can use the TIMESTAMP
and TIMESTAMP_NTZ
data types to handle date and time values, similar to the DATETIME
type in PostgreSQL. However, Databricks does not have a direct equivalent to PostgreSQL's TIMEDELTA
type
https://docs.databricks.com/ja/sql/language-manual/sql-ref-datatypes.html

