Home » SQL & PL/SQL » SQL & PL/SQL » getting last day of the month - feedback asap pls
icon12.gif  getting last day of the month - feedback asap pls [message #186728] Wed, 09 August 2006 04:32 Go to next message
marge
Messages: 1
Registered: August 2006
Junior Member

My objective in the program below to extract the last day based on the given year and month.

DECLARE
 AGYEAR  number;
 AGBMON  number;
 Last_date date;
BEGIN
 AGYEAR  := 2001;
 AGBMON  := 1;
 Last_date date := ?
END;


Hoping for feedback asap. Razz
Thanks.
Re: getting last day of the month - feedback asap pls [message #186730 is a reply to message #186728] Wed, 09 August 2006 04:45 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Have you even tried to search?
Previous Topic: New install of 9i, unable to login
Next Topic: Timestamp date format conversion
Goto Forum:
  


Current Time: Tue Dec 06 10:06:27 CST 2016

Total time taken to generate the page: 0.04795 seconds