select year,week,date1,to_char(date1,'Day') day from ( select

i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeks
i need 1st dd for evry wk

Question Posted / kavitha singh

1 Answers
6323 Views
Aspire, I also Faced
E-Mail Answers

Answer Posted / kavitha singh

select year,week,date1,to_char(date1,'Day') day
from
(
select year, week,
next_day( to_date( '04-jan-' || year, 'dd-mon-yyyy' ) + (week-2)*7, 'mon' ) date1
from (select '2011' year, rownum week from all_objects where rownum <= 53 ))

Is This Answer Correct ?

10 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I save a stored procedure?

1069

How do I edit a stored procedure?

1049

What is the benefit of foreign key?

1069

what are all the different types of indexes? : Sql dba

1104

Mention what are the benefits of pl/sql packages?

1156

what is datawarehouse? : Sql dba

1066

Which software is used for pl sql programming?

1034

What is compilation error in pl sql?

1025

how to use myisamchk to check or repair myisam tables? : Sql dba

1017

What is out parameter used for eventhough return statement can also be used in pl/sql?

1124

Why do we use function in pl sql?

1114

How long will it take to learn pl sql?

981

Explain the the update statement in sql?

1105

Is join and inner join the same?

1044

Can a table have no primary key?

1110