Use TO_char() function , to get mont , day and year
for example :
select to_char(sysdate,'MM') from dual;
return month in number
select to_char(sysdate,'Month') from dual;
return month in Word
select to_char(sysdate,'yyyy') from dual;
return Year or date
select to_char(sysdate,'dd') from...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.