'DATEPART and DATEFIRST alternative for redshift

I'm trying to run

SELECT DATEPART(week, date(date)), MIN(date)

in Redshift with the start day being Saturday. I tried using different syntax for SET DATEFIRST but it seems like it's not supported (or I just can't find the correct syntax for redshift). Are there any alternatives available?

The documentation page only shows information for extracting a specific dow (day of week): https://docs.aws.amazon.com/redshift/latest/dg/r_DATE_PART_function.html

sqlamazon-redshiftdatepart


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions