OraFAQ Forum: SQL & PL/SQL » Figure out if it is the end of the month

Home » SQL & PL/SQL » SQL & PL/SQL » Figure out if it is the end of the month

Wed, 13 February 2002 05:33

mary
Messages: 19
Registered: November 1999

Junior Member

How can you figure out if it is the end of the month
and write a sql statement to be added to your pl/sql block to execute a procedure? Thanks

Wed, 13 February 2002 06:12

Grant
Messages: 578
Registered: January 2002

Senior Member

select LAST_DAY(trunc(sysdate)) from dual;

Previous Topic:	Re: PL/SQL script
Next Topic:	How to calculating the difference between dates on different rows

Goto Forum:

]

Current Time: Fri Apr 19 14:44:04 CDT 2024