How to Alter DateStyle in Vertica
How to alter the DATE STYLE for all the session that connect with the vsql client. Edit the file /opt/vertica/config/vsqlrc and add the following lines
SET DATESTYLE TO SQL, DMY;This will set date style to DAY/MOUNTH/YEAR format. You can chose other types of formats as well depending on your location.
Value Interpretation Example
MDY month-day-year 12/16/2011
DMY day-month-year 16/12/2011
YMD year-month-day 2011-12-16
ISO ISO 8601/SQL
standard (default) 2011-12-16 07:37:16-08
PROGRES verbose style Fri Dec 16 07:37:16 2012 PST
SQL traditional style 12/16/2011 07:37:16.00 PST
GERMAN regional style 16.12.2011 07:37:16.00 PST