Determining if Year is a Leap Year...

[sarah]

Hello,

What's the best way to determine if a year is a leap year in Vertica?

Here is what I was thinking for a function:

Code: Select all

CREATE OR REPLACE FUNCTION is_leapyear(d timestamp)
RETURN BOOLEAN
AS BEGIN
  RETURN DECODE(DAY(LAST_DAY(TO_DATE(year(d) || '-02-01', 'YYYY-MM-DD'))), 29, TRUE, FALSE);
END;

Example run ...

Code: Select all

dbadmin=> SELECT sysdate, is_leapyear(sysdate);
          sysdate           | is_leapyear
----------------------------+-------------
 2012-11-14 09:09:14.037244 | t
(1 row)

Is this the most (or at least an) efficient method?

Thanks!

[id10t]

Hi!

https://github.com/sKwa/vertica/blob/ma ... _funcs.sql (in the end)

[sarah]

Thanks, sKwa!!! That is a VERY useful link! I'll create those is_leap_year functions in our environment

[id10t]

Hi!

Only one advice: don't trust to anyone, do tests, check everything you take from others, especially be careful with production environment.
(like a small child but it's not joke)