Post reply

how to reset week start date

  • March 9, 2009 at 12:15 am

    #202119

    hi all,

    In my system @@datefirst giving 7. I want to change it to 5

    how can i do this

    thanks in advance

    Regards

    Durgesh J

  • March 9, 2009 at 12:32 am

    #955801

    SET DATEFIRST 5

    "Keep Trying"

  • March 9, 2009 at 12:57 am

    #955804

    set datefirst 5 will do that.

    But it is session based. If you open another session, you can see 7.

    karthik

  • March 9, 2009 at 3:11 am

    #955837

    Yes its only for the current session. DateFirst acutally depends on the language chosen. For english it 7 - Sunday.

    "Keep Trying"

  • March 9, 2009 at 6:26 pm

    #956502

    Chirag (3/9/2009)

    Yes its only for the current session. DateFirst acutally depends on the language chosen. For english it 7 - Sunday.

    For English in Australia it's 1 - Monday.

    It depends not on language but on chosen locale.

    _____________
    Code for TallyGenerator

  • March 10, 2009 at 12:02 am

    #956584

    is there any option to set the datefirst server level instead of sesssion level?

    karthik

  • March 10, 2009 at 6:28 am

    #956718

    You can set the default language for the server: sp_configure;

    or set the accounts default language: ALTER LOGIN SET DEFAULT_LANGUAGE;

    or the current process, as seen above.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply