Vertica Documention missing ISO DAYOFWEEK format option ('ID')

Emanuel_Pordes_1

Hi,

 

Even though it works, the 'ID' option for date formatting to display the ISO DAYOFWEEK (Sunday = 7, Monday = 1) isn't documented even though other ISO options are (DAYOFYEAR, WEEKOFYEAR, etc)

 

It looks like a simple omission from the docs.

 

https://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/Formatting/TemplatePatternsForDateTimeFormatting.htm

 

 

vertica=> SELECT DAYOFWEEK('2015-08-23 10:00:00'::timestamp) AS "day_of_week";
 day_of_week
-------------
 1
(1 row)


vertica=> SELECT TO_CHAR('2015-08-23 10:00:00'::timestamp, 'ID') AS "day_of_week";
 day_of_week
-------------
 7
(1 row)

Thakur

the reference to the document is available

https://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/Date-Time/DAYOFWEEK_ISO.htm

 

Emanuel_Pordes_1

Yes, the function is documented but the TO_CHAR timstamp format option is not.