Hetal wrote:
> On Mar 5, 12:40 pm, Luuk <L...@invalid.lan> wrote:
>> Hetal schreef:
>>
>>
>>
>>> 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
>> i do understand your question, but i find it dumb to have this option
>> available in a database.
>>
>> because i believe that the first day of the week has nothing to do with
>> a database, so any statement like 'Set DateFirst 2' is useless.
>>
>> and you can read all about the week functions available in MySQL at:http://dev.mysql.com/doc/refman/5.0/...functions.html
>>
>> mysql> Select DATEPART(WeekDay, GetDate())
>> -> ;
>> ERROR 1054 (42S22): Unknown column 'WeekDay' in 'field list'
>> mysql>
>>
>> --
>> Luuk
>
>
> Luuk,
>
> This query i provided is intended to run on MSSQL and not MySQL.
> Anyways, thanks for your inputs.
>
> Hetal.
>

(Top posting fixed)

I agree with Luuk. A database's job is to store and retrieve data. The
day of the week should be immaterial to a database. If you want to
change it, use a programming language such as PHP.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================