Is there a function in Vertica is equivalent to DATENAME in SQL

Comments

• Options

  colin_loghin ✭

  September 2013

  I would wrap a SQL function around a case statement supported by the date_part function : CREATE OR REPLACE FUNCTION datename1(part varchar, dt Date) RETURN varchar AS BEGIN RETURN CASE date_part(part ,dt) WHEN 1 then 'Jan' when 2 then 'Feb' else 'Dec' end ; END; select datename1('month','2012-02-22'); datename1 ----------- Feb (1 row)

  0
• Options

  Xiukun_Chang

  September 2013

  That is what I did in a similar way, but just wondering if there is an existing Vertica function that I am not aware of. Thanks.

  0
• Options

  Kiryl_Mauryshch

  September 2013

  There is no function that would extract Month as a word. Similar to DATE_PART, there is an EXTRACT function which would return the number. SELECT EXTRACT(MONTH FROM TIMESTAMP '2001-02-16 20:38:40'); Result: 2

  0