Hi Luuk.

Can you please try running this query and check what the output is.
Just to brief up, it will return the day of week.

Select DATEPART(WeekDay, GetDate())

And then try running this query and see what the day of week shows up
as .

Set DateFirst 2
Select DATEPART(WeekDay, GetDate())

The output of first query will differ from the output of second query.
So my question here is, do we have something similar in MySQL that
will let us have the functionality similar to "Set DateFirst 2"
statement?

Thanks,
Hetal.

On Mar 5, 10:46 am, Luuk <L...@invalid.lan> wrote:
> 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