- 1589 Views
- 2 replies
- 2 kudos
Resolved! Convert Week of Year to Month in SQL?
Hi all, Was wondering if there was any built in function or code that I could utilize to convert a singular week of year integer (i.e. 1 to 52), into a value representing month (i.e. 1-12)? The assumption is that a week start on a Monday and end on a...
- 1589 Views
- 2 replies
- 2 kudos
Latest Reply
- 2 kudos
we need old parser as new doesn't support weeks. Than we can map what we need using w - year of year and u - first day of the week:spark.sql("set spark.sql.legacy.timeParserPolicy=LEGACY") spark.sql(""" SELECT extract( month from to_date...
- 2 kudos