Post reply

nvarchar fields showing as US dates ?

  • June 6, 2003 at 2:41 am

    #59673

    We have dates sotred as character nvarchar fields in dd/mm/yyyy format but when you display or update these they are showing as mm/dd/yyyy. The server itself has the correct regional setting so suspect this is something embedded within SQL Server 2000 which defaults to interpret fields which look like dates and automatically display ten in US format.

  • June 6, 2003 at 4:10 am

    #460124

    It is probably the user login language setting. Look under EM and view anty particular user. Settings for server serve as a default when creating user accounts but when changed does not affect existing accounts.

    If you find this to be the case and need to make sure all the users are set the same look here for a script to help.

    http://www.sqlservercentral.com/scripts/contributions/325.asp

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

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