Extract Transform & Load
Nav
Home
BigData-Blog
LINK
About Me
8/16/18
Last Day of current month and Previous month Oracle sql
SELECT LAST_DAY(SYSDATE) last_day_current_month,
LAST_DAY(add_months(SYSDATE,-1)) last_day_prev_month
FROM DUAL;
0 comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment