Home » RDBMS Server » Server Administration » Starting Week from Saturday
Starting Week from Saturday [message #205583] Sun, 26 November 2006 07:48 Go to next message
muhammadaqeel
Messages: 13
Registered: November 2006
Location: Jeddah Saudi Arabia
Junior Member

Asslam o alaikum,
brother and sisters i am using oracle 10g and want to start the week from saturday. Can anyone help me in doing so?
Regard,
.....
Re: Starting Week from Saturday [message #205585 is a reply to message #205583] Sun, 26 November 2006 08:04 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please re-phrase. I do not understand what you are talking about.

[Updated on: Sun, 26 November 2006 08:16]

Report message to a moderator

Re: Starting Week from Saturday [message #205604 is a reply to message #205585] Sun, 26 November 2006 12:33 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
The first day of a week is determined by the NLS_TERRITORY parameter. Among other things (such as date format, decimal character and group separator etc.), it specifies first day of the week.

Set it to any valid value which supports Saturday as the first day of the week (I don't know any; there are countries that take Sundays or Mondays as the beginning, but Saturday ... no idea).

If there's no such a country, perhaps you could create your own function which would return "current first day of the week - 1" (or -2, depending on whether it is set to Sunday or Monday).
Re: Starting Week from Saturday [message #205662 is a reply to message #205604] Mon, 27 November 2006 00:34 Go to previous message
muhammadaqeel
Messages: 13
Registered: November 2006
Location: Jeddah Saudi Arabia
Junior Member

Thanks a lot brother for your great help
I am really satisfied now.
May Allah bless you with great success and prosperity
Best Regards,
...............
Previous Topic: DBMS_JOB : every minute <99.99% "do nothing"> Job disappears
Next Topic: checkpoint time
Goto Forum:
  


Current Time: Fri Dec 02 17:00:50 CST 2016

Total time taken to generate the page: 0.25560 seconds