May 20, 2010 at 3:31 am
Kannbiran, when u change the dateformat to DMY, the insert statement must also follow suite and contain rows like '01-Mar-2010' or '30-03-2010' etc..
May 21, 2010 at 6:04 am
The date format used depends on a number of settings (see Books Online Date and Time Data Types and Functions (Transact-SQL) for the details).
There isn't a default date format for a database, but it is set to a value consistent with the current language. There is a server-wide default language, and also a default language for each login. See ALTER LOGIN and 'default language' - again in Books Online.
The relationship between date format and language can be seen in the compatibility view sys.syslanguages.
For example, the following languages all default to use DMY:
German
French
Danish
Spanish
Italian
Dutch
Norwegian
Portuguese
Finnish
Czech
Polish
Romanian
Slovak
Slovenian
Greek
Bulgarian
Russian
Turkish
British English
Estonian
Brazilian
Arabic
Thai
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply