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
6256 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 to use distinct and count in sql query? Explain

1035

what are the join types in tsql? : Transact sql

1072

Is sql microsoft?

1062

What does trigger mean in psychology?

971

What is meant by cursor in sql?

1007

Why cross join is used?

1084

how to install mysql? : Sql dba

1119

Which is better stored procedure or query?

964

What is the mutating table and constraining table?

1032

What is user defined functions?

990

What is faster join or subquery?

1018

What is a string data type in sql?

1049

What is a memo field?

976

Is oracle and sql same?

1020

how would you get the current date in mysql? : Sql dba

978