Home » SQL & PL/SQL » SQL & PL/SQL » Find the Last Friday of the current month (PL/SQL)
Find the Last Friday of the current month (PL/SQL) [message #214283] Mon, 15 January 2007 12:17 Go to next message
hemanthjava
Messages: 2
Registered: January 2007
Location: Bangalore
Junior Member

Please help me write a PL/SQL Program to find the last friday of the current Month
Re: Find the Last Friday of the current month (PL/SQL) [message #214285 is a reply to message #214283] Mon, 15 January 2007 12:32 Go to previous messageGo to next message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
Search the board as this question was already asked.
Re: Find the Last Friday of the current month (PL/SQL) [message #214296 is a reply to message #214283] Mon, 15 January 2007 13:26 Go to previous messageGo to next message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
select next_day(last_day(sysdate) - 6,'FRI') from dual;
Re: Find the Last Friday of the current month (PL/SQL) [message #214624 is a reply to message #214283] Wed, 17 January 2007 05:35 Go to previous message
Kprattip
Messages: 15
Registered: January 2006
Location: INDIA
Junior Member
select next_day(last_day(sysdate) - 7,'FRIDAY') from dual;

Kiran Prattipati
Previous Topic: Exception handling for Package Variables
Next Topic: Tree Walking
Goto Forum:
  


Current Time: Wed Dec 07 20:31:34 CST 2016

Total time taken to generate the page: 0.10873 seconds