Post reply

Problem with date format

  • June 15, 2009 at 1:48 pm

    #206266

    Hello

    I have a program that represents date in dd/mm/yy format and we are having problems with a database that expects date in the format mm/dd/yy. I we use SET DATEFORMAT the problem is solved but we don´t know how to make the change permanent for that database or that session login.

    Thanks in advance.

  • June 15, 2009 at 1:51 pm

    #1009894

    try changing date format under regional settings in control panel on the server to dd/mm/yyyy and see if it works. probably u might hv to restart the sql server.


    Pradeep Singh

  • June 15, 2009 at 2:01 pm

    #1009900

    Thanks for you answer.

    I can´t do that because it´s one of my customers server. I can change settings in my session login and database only. If you know how to do that for my session login only it would be of great help

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

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