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.
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)