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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
