Post reply

Convert char to datetime. dmy instead of mdy?

  • April 27, 2011 at 1:50 am

    #238475

    I have an old application that runs on sql server 2000. I managed to get it working with sql server 2005 (for my new 64 bit windows 7 computer). I only have one problem: when I execute a report in the application (so this querry cannot be changed) which uses a date, the interpretation is wrong (mdy instead of dmy).

    The application cannot be changed, so how can I make sql server 2005 express use the dmy format? I'm a complete novice with sql server so please keep that in mind when answering.

    In short I would like to configure SQL server 2005 express that it should interpret the date as dmy instead of mdy (as it does now).

    In front I'd like to thank you very much for your efforts to help me.

  • April 27, 2011 at 2:01 am

    #1316398

    This link should help you

    http://www.karaszi.com/SQLServer/info_datetime.asp


    Clear Sky SQL
    My Blog[/url]

  • April 27, 2011 at 2:26 am

    #1316404

    Hello Dave,

    Thanks for your reply. The article describes how dates can be inputted in sql server so it will interpret it in the right way. The problem is I can't change the input the application gives to SQL server so I get error message: Date <='12-31-2011'

    I want to configure sql server itself so it completely uses mdy (and thus solves the input misunderstanding without having to change the input because the application is closed source and therefor I can't). The application was made for SQL server 2000 where it was handled differently (there was no error when using the 2000 version in the same report).

  • April 27, 2011 at 6:07 am

    #1316495

    I solved it by changing the language setting in the user with SQL Server Management Studio Express

Viewing 4 posts - 1 through 3 (of 3 total)

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