OraFAQ Forum: Server Administration » Starting Week from Saturday

Home » RDBMS Server » Server Administration » Starting Week from Saturday

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Starting Week from Saturday [message #205583]

Sun, 26 November 2006 07:48

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,
.....

Report message to a moderator

Re: Starting Week from Saturday [message #205585 is a reply to message #205583]

Sun, 26 November 2006 08:04

Mahesh Rajendran
Messages: 10707
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

Littlefoot
Messages: 21818
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).

Report message to a moderator

Re: Starting Week from Saturday [message #205662 is a reply to message #205604]

Mon, 27 November 2006 00:34

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,
...............

Report message to a moderator

Previous Topic:	DBMS_JOB : every minute <99.99% "do nothing"> Job disappears
Next Topic:	checkpoint time

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 06:40:33 CDT 2024