Converting TSQL datepart(week) to Databricks SQL
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-25-2023 02:30 AM
Hi!
I'm converting an existing TSQL script into Databricks SQL.
In TSQL, the below script returns 1
select datepart(WEEK,'2022-01-01')
In Databricks SQL, then below script returns 52.
select date_part('week','2022-01-01')
Does Databricks SQL have something equivalent where Jan 1 is the first week of the year? Thank you in advance.
