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
- 1 Answers
- 5787 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
What are the two types of exceptions.
What is database white box testing and black box testing?
What is the difference between between and in condition operators?
What is user defined functions?
Does truncate release storage space?
Can ddl statements be used in pl/sql?
How many types of functions are there in sql?
What is difference between cursor and trigger?
what tools available for managing mysql server? : Sql dba
What is sqlerrm?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
Explain the difference between sql and mysql.
What is raid? How does it help storage of databases?
What is difference between function and trigger?
how many values can the set function of mysql take? : Sql dba
