for Example there is a date '2021-08-21', I need to convert it to '2021-05-01' I am confused with right functions to use as I want it to use it in Apache Spark SQL.
CodePudding user response:
You can use add_month first and then use date_trunc to get the first day of the result of add_month
.
select date_trunc('MONTH', add_months(date, -3))