Re: sql date worries

2001-03-07 Thread Bob Hall
>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

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 date(week(10),1)