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