Below is the query to return day of week from Redshift database. It returns a numeric output . 1 for Monday, 2 for Tuesday , and so on
select extract(dow from now());
Below is the query to return day of week from Redshift database. It returns a numeric output . 1 for Monday, 2 for Tuesday , and so on
select extract(dow from now());