Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- CASE
- WHEN MOD(TO_NUMBER(TO_CHAR(TO_DATE('02.01.1600','DD.MM.YYYY'),'YYYY')),4) = 0
- AND MOD(TO_NUMBER(TO_CHAR(TO_DATE('02.01.1600','DD.MM.YYYY'),'YYYY')),100) = 0
- AND MOD(TO_NUMBER(TO_CHAR(TO_DATE('02.01.1600','DD.MM.YYYY'),'YYYY')),400) = 0 THEN 366
- ELSE 365
- END
- FROM DUAL d
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement