Hi Begun ,
I am very eager to know the reason why 27th Nov is taken as the base for each
year. Can you please explain me the reasons. This query is really helpful for me .
Thanks Regards,
Shankar
-Original Message-
Sent: Saturday, March 29, 2003 11:39 AM
To: Multiple
I have found out the reasons. Thanks for your information.
-Original Message-
Sent: Monday, March 31, 2003 1:34 PM
To: Multiple recipients of list ORACLE-L
Hi Begun ,
I am very eager to know the reason why 27th Nov is taken as the base for each
year. Can you please explain me
I have found out the reasons. Thanks for your information.
That's good.
P.S.: 27 of Nov is my birthday. :)
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ:
Thanks a lot!!!
-Original Message-
Sent: Saturday, March 29, 2003 1:09 AM
To: Multiple recipients of list ORACLE-L
Hello!
Sesi Odury wrote:
Given a week between (1 - 52) for a particular year can we get all the
dates within that week. Is there a function to do this in SQL???
Using
Hi,
Given a week between (1 - 52) for a particular year can we get all the dates within
that week. Is there a function to do this
in
SQL l
1 select x.d
2 from (select to_date(rownum, 'DDD') d,
3 to_number(to_char(to_date(rownum, 'DDD'), 'IW')) week
4from all_objects
5where rownum 366) x
6* where x.week = week_num
You may have a problem with leap years, but it's basically the idea.
Stephane
There are days when I just feel lucky if I can understand your code, let
alone come up with something smarter.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, March 28, 2003 8:39 AM
To: Multiple recipients of list
Maybe a slight improvement. I borrowed heavily from Jonathan
Gennicks pivot table article for this. :)
http://otn.oracle.com/oramag/oracle/02-sep/o52sql.html
select x.d
from (
select to_date(rownum, 'DDD') d,
to_number(to_char(to_date(rownum, 'DDD'), 'IW')) week
from
Hello!
Sesi Odury wrote:
Given a week between (1 - 52) for a particular year can we get all the
dates within that week. Is there a function to do this in SQL???
Using the simple statement below you can get the first date of the week
(according to ISO standard). Then you can either add 6 to get