How i will get DATENAME in vertica?

Haris_NI

In sql i will get DateName from the following query 

SELECT DATENAME(dw,'10/24/2013') as theDayName to return 'Thursday'

have any equivalent function in Vertica?

eli_revach

Vertica as the abiliy to return the date of the week as numeric value ,  you can do someting like this to have it as a string . 

SELECT  case  EXTRACT(DOW FROM TIMESTAMP '10/24/2013')       
         when 0 then 'Sunday'
          when 1 then 'Monday'
          when 2 then 'Tuesday'
          when 3 then 'Wednesday'
          when 4 then 'Thursday'
          when 5 then 'Friday'
          when 6 then 'Saturday'
       end 

Daniel_Leybovic

Hi!

You can find some useful functions here: https://github.com/sKwa/vertica/blob/master/UDFSQL/sql_funcs.sql

• is_int
• month_name
• weekday_name
• random_ts [between ts1 and ts2]
• midpoint_timestamp
• season
• is_leap_year
• current_quarter_last_day
  

Best (aka sKwa)

Bhawana

Hi,

You can also check out this link:

https://community.vertica.com/vertica/topics/is_there_a_function_in_vertica_is_equivalent_to_datenam...

Regards

Bhawana

norbert_krupa

Use TO_CHAR formatting:

SELECT TO_CHAR(TIMESTAMP '2014-08-21 14:34:06', 'DAY');

This returns the full uppercase day name. Day gives the mixed-case day name, and day gives the lowercase day name.