dear
i've an old sql server 2000, with default date format mm/dd/yyyy
i've installed a new one SQL server 2005 , my application did't work with its date format
i wan't to change SQL 2005 default date format to mm/dd/yyyy instead of dd/mm/yyyy
regards
Dates are displayed as configured for the user (its a session setting). But formatting of the dates should be made in the front end / presentation layer. Don′t do that on the server, try to pass the date in a more generic format like ISO Date. 20061114
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
