Obtain week of a date

I need to get the week out of the year depending on the date, how could I?


In the UI, you can click on Add Field and user the following sql:

date_part('week', "my_date_col")

That will get you the week number (1-52) of a given DATE, TIME or DATETIME field.

1 Like

hey men thank you, It works very well.