The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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

In MS SQL, I can get month name using SELECT DATENAME(month,'2007-10-30 12:15:32.1234567 +05:10'); to return October. Do we have an equivalent function in Vertica? Thanks. Sean


  • 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)
  • 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.
  • 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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file