Reference Guide
>
TDV Support for SQL Functions
>
Date Functions
>
WEEK
WEEK
Returns the week number for a given date.
Syntax
WEEK(date);
Example
SELECT WEEK('2020-06-20');