Post reply

sql default date format issue

  • March 5, 2015 at 3:21 am

    #301719

    Hi everybody,

    the problem is my website(c#) is working fine with it's database(sql 2008), but when i restored the db on another machine each query which wants to insert a datetime field to db gets error.

    Both machines have windows server 2008 R2 standard and SQL server 2008 Enterprise with sp1.

    Thanks in advance

  • March 5, 2015 at 4:21 am

    #1781874

    If I'm reading your question correctly, it might simply be a case of changing the language that the login connects under, for instance from English to British English - that is very often the cause of dates being in the wrong format.

    Does that help at all?

  • March 5, 2015 at 4:31 am

    #1781876

    This is also a good demonstration of why it's always best to pass datetime data in an unambiguous format yyyy-mm-dd. Not just shifting boxes, I've even seen a service pack change the default date format from British to Awful US format

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.

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

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