I did something similar to this recently. I ended up using the following
select date_sub(curdate(), interval(dayofweek(curdate()) + (($week - week) *
7) - 1) DAY) as mydate.
This was in php and ahead of time I set $week as select week(curdate()).
It could easily be extended with year.
Phil
On
Pintér Tibor wrote:
Ananda Kumar írta:
Hi All,
I think i worked on this and found the results.
I did the below.
1. Multiplied the week_of_the_year with 7 (7 days per week), to get the
total number of days from begning of the year.
2. used mysql function makedate
makedate(year,number of d
Ananda Kumar írta:
Hi All,
I think i worked on this and found the results.
I did the below.
1. Multiplied the week_of_the_year with 7 (7 days per week), to get the
total number of days from begning of the year.
2. used mysql function makedate
makedate(year,number of days from the start of
Hi All,
I think i worked on this and found the results.
I did the below.
1. Multiplied the week_of_the_year with 7 (7 days per week), to get the
total number of days from begning of the year.
2. used mysql function makedate
makedate(year,number of days from the start of the year)
makedate(
HI All,
I have table which stores week_of_the_year and year.
For example
week_of_yearYEAR
32 2008
I want to convert this into the date. That is , i need to get the date of
first day of the week 32.
some thing like
03-AUG-2008.
Regards
anandkl
