All pastes #922561 Raw Edit

Miscellany

public text v1 · immutable
#922561 ·published 2008-02-28 21:33 UTC
rendered paste body
SELECT (CASE
         WHEN MONTHS_BETWEEN(TO_DATE('2008-01-01', 'YYYY-MM-DD'), SYSDATE) > 0 THEN
          1
         ELSE
          -1
       END) "DIFFERENCE"
  FROM DUAL