Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT TO_char(TRUNC(ADD_MONTHS(TO_DATE(sysdate, 'mm/dd/yyyy'), -1),'MM'), 'dd.mm.yyyy') AS prethoden, EXTRACT(MONTH FROM sysdate) AS momentalen FROM dual
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement