hi all,

I have 2 variables, varYEAR and varWEEK (ie: 2010 and 50)

I'd like to know the days of this week (it starts on mondays). Or at
least the first day of this week.

2010-12-13
2010-12-14
2010-12-15
2010-12-16
2010-12-17
2010-12-18
2010-12-19

It seems the mysql date and time functions only take date variables and
no week number variable.

any hint ?

regards,

f.

SELECT STR_TO_DATE('201050 Monday', '%X%V %W');
+-----------------------------------------+

Le 16/12/2010 19:22, strawberry a écrit :

thanx a lot

regards,

f.

On 16-12-10 19:05, fabrice régnier wrote:
set @A:=(week(now())-week('2010-01-01')-1)*7;
select ADDDATE('2001-01-01', x+@a) from number where x between 3 and 9;

Where the 'number'table contains integers, at least from 3 until 9


--
Luuk