Home » SQL & PL/SQL » SQL & PL/SQL » Get workweek in pl/sql (windows)
icon5.gif  Get workweek in pl/sql [message #322714] Mon, 26 May 2008 01:02 Go to next message
gerra_lime
Messages: 3
Registered: May 2008
Junior Member
need help.. just learning pl/sql.. can someone tell me how to get workweek in pl/sql using sysdate?

Thank you so much Smile
Re: Get workweek in pl/sql [message #322717 is a reply to message #322714] Mon, 26 May 2008 01:20 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

just a clue

   
     Select to_char(sysdate,'d') from dual;

  


try and get your solution as u wish

kanish
Re: Get workweek in pl/sql [message #322719 is a reply to message #322717] Mon, 26 May 2008 01:21 Go to previous messageGo to next message
gerra_lime
Messages: 3
Registered: May 2008
Junior Member
nice! /no1
thanks alot... got it!!!! Smile
Re: Get workweek in pl/sql [message #322728 is a reply to message #322719] Mon, 26 May 2008 01:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64107
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Take care this is just a clue not a solution.

Regards
Michel
Re: Get workweek in pl/sql [message #322730 is a reply to message #322714] Mon, 26 May 2008 01:58 Go to previous message
gerra_lime
Messages: 3
Registered: May 2008
Junior Member
yes! thank you so much for the clue.. Smile
it helped alot..

take care Smile
Previous Topic: regarding performance of database
Next Topic: Update record Snapshot
Goto Forum:
  


Current Time: Mon Dec 05 04:37:41 CST 2016

Total time taken to generate the page: 0.08054 seconds