Post reply

SQL Date N Time Settings

  • March 7, 2003 at 2:41 am

    #158968

    Good morning, I am currently experiencing problems with SQL. I am inputting a date into the database but it shows as USA even though I have checked the regional settings of the server and they say UK. Is there any other reason the dates could be screwed up.

    Thanks

    Gary J

  • March 7, 2003 at 4:53 am

    #450517

    Check the SQL Server language in the SQL Server Properties (change here does not effect any of the users) and for the user. hese directly effect the dateformat output.

    See related FAQ here http://www.sqlservercentral.com/faq/viewfaqanswer.asp?faqid=256

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

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