oracle pl sql actual date writing as in excel

53 Views Asked by At

How to write actual date in oracle pl sql

EOMONTH(Today())?

I know that Today() fuction is SYSDATE, but will it give me the in last day of month format?

1

There are 1 best solutions below

0
Koen Lostrie On BEST ANSWER

The function LAST_DAY returns the last day of the month for the date that is passed as argument.

koen>SELECT last_day(sysdate) FROM dual;

   LAST_DAY(SYSDATE) 
____________________ 
31/03/22             

koen>