To_date function in Vertica format?
14,061
Try this:
SELECT TO_CHAR(CURRENT_TIMESTAMP, 'DD/MON/YYYY');
Author by
Up_One
Updated on July 24, 2022Comments
-
Up_One almost 2 years
How can I get Vertica function
to_date('','format')
do output like this:DDMonYYYY - 01/ABR/2012
and not like it does (
01-04-2012
)?!dbadmin=> select now(); now -------------------------------- 19/09/2012 11:03:48.284339 BRT (1 row) dbadmin=> show datestyle; name | setting -----------+---------- datestyle | SQL, DMY (1 row)