Obtain week of a date

1

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

2

Hi,

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
3

hey men thank you, It works very well.