Hetal schreef:
> Hi..
>
> There is a function in MSSQL that sets you set what the first day of
> the week should be. For e.g. if i say Set DateFirst = 1, the first day
> of the week is set to Monday. If DateFirst = 2, then first day of the
> week is set to Tuesday.
>
> I would like to do something similar in MySQL but i am unable to find
> any equivalent function in MySQL. Your help will be very much
> appreciated.
>
> Thanks,
> Hetal.

I do think that there's no such function,
as, in my opninion, such a function should not even exist in MSSQL,
because the first day of the week had nothing to do with databases,
its an agreement between some people stating on which day the week starts

see i.e.: http://en.wikipedia.org/wiki/ISO_week_date
A date is specified by the ISO year in the format YYYY, a week number in
the format ww prefixed by the letter W, and the weekday number, a digit
d from 1 through 7, beginning with Monday and ending with Sunday. For
example, 2006-W52-7 (or in compact form 2006W527) is the Sunday of the
52nd week of 2006. In the Gregorian system this day is called 31
December 2006.



--
Luuk