CODEWITHSUNDEEP
isodenodofiscalvql
Ezgi Turalı
Ezgi Turalı

Reputation: 1

Denodo/VQL ISO_WEEK

I wanted to work with iso week in Denodo. I could not find any functions or calculations.

I wanted to use this code below:

GETWEEK("ISO_WEEK", ADDWEEK(CURRENT_DATE(), 1))

Obviously there is no ISO_WEEK function. Have you encountered such a problem before?

Upvotes: 0

Views: 150

Answers (1)

bklein
bklein

Reputation: 71

It's my understanding that you are looking to work with ISO weeks in Denodo and encountered an issue with the code using the "GETWEEK" function.

The "GETWEEK" function in Denodo follows the ISO standard and directly returns the day of the week as an integer. Therefore, you can use the function as follows:

GETWEEK(ADDWEEK(CURRENT_DATE(), 1))

This code will work without the need for the first argument "ISO_WEEK."

For more detailed information about the "GETWEEK" function and its usage, you can visit this link on the Denodo Community: GETWEEK Function in Denodo.

Hope it helps

Upvotes: 0

Related Questions