Difference Between IYYYIW and YYYYWW

[rajveersinghsisodiya]

Hi,

what is difference between to_char(START_DATE + 1,'IYYYIW') and to_char(START_DATE + 1,'YYYYWW').

because when i have used first expression it will give like 201508 and second one will give 201507.

Please explain how IYYYIW is different from YYYYWW ?

[AbhijitBansode]

to_char() is not a valid QlikView function.

Please refer the help document of your database software in which you are using this function.

[Miguel_Angel_Baeyens · Accepted solution]

Abhijit Bansodeis right. These are not QlikView or Qlik Sense functions.

If you are talking about Oracle to_char(), there are important differences:

IYYY format uses the ISO standard and IW returns the week of the year from 1 to 53 based on the ISO, while WW returns a value between 1 and 52 (see Format Models from the Oracle Docs reference).

They are similar to what you can achieve using Week() and YearWeek() in QlikView (Redefining the Week Numbers by Henric Cronström is a must)

Miguel

[rajveersinghsisodiya]

Thanks For Miguel A. Baeyens