Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-22-2023 09:16 PM
This worked for me.
SELECT
your_date_column,
CASE
WHEN DAYOFYEAR(your_date_column) <= 7 THEN 'Week 1'
ELSE 'Week ' || CAST(CEIL((DAYOFYEAR(your_date_column) - 7) / 7.0) + 1 AS STRING)
END AS WeekNumber
FROM your_date_table;
