Reply
Highlighted
New Contributor
Posts: 1
Registered: ‎02-18-2019

Hive SQL query to find the week of quarter

Hi All,

 

I need help on writing sql query to find the week of quarter. I had a querie which works in sql server

(DATEDIFF(DD, DATEADD(QQ, DATEDIFF(QQ, 0, getdate()), 0), getdate()) / 7) + 1 AS WeekOfQuarter

 

Please suggest work around.

 

Thanks

Amit Sharma

 

Announcements