Date query problem (hard one)

2001-03-08 Thread Adams, Antoine A SSI-ISES-56
I've been strugling with a query for some time now and I can't get the desired answer from mysql. The desired answer: a date (bv. 2001-02-08) What is the input: a week number What date do I need: The date of the monday where week = x the idea was: select date(week(10),1); But offcourse

sql date worries

2001-03-07 Thread Adams, Antoine A SSI-ISES-56
Hi all, Im kind of strugling with a query for some time now and I need extra input: What is the desired answer from mysql: a date. what is the input: a week number What dat do I need: The date of the monday (week starts at sunday) in the weeknumber. something like: select