Default date format

[usli06]

How do I set the default date format on a per session basis?

[id10t]

Hi!

Is this what you need --- SET DATESTYLE ?

[usli06]

Yeah! Thanks!

However, we have folks logging in from China and they want the dates to look like this "2012.07.18". I don't see this as an option DATESTYLE parameter.

[id10t]

HI usli!

I asked about it on my.vertica.com portal - http://my.vertica.com/forums/topic/date-style/. Follow for answer in my.vertica portal.

[usli06]

Thanks for checking sKwa!

It's also a bug in 5.0.11:

Code: Select all

usli06=> SET DATESTYLE TO GERMAN, YMD;
SET
usli06=> SELECT now();
              now
--------------------------------
 24.07.2012 07:46:51.438183 EDT
(1 row)

usli06=> SELECT version();
               version
-------------------------------------
 Vertica Analytic Database v5.0.11-0
(1 row)

[usli06]

Anyone hear when this bug might be resolved?