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 the year)
> makedate(2008,224)
> select makedate(2008,224);
> +--------------------+
> | makedate(2008,224) |
> +--------------------+
> | 2008-08-11 |
this is definitely wrong, since you dont care about the fact that the
frist day of the year is not always Monday
or do I misunderstand something?
t
