Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-01 : 23:13:35
|
| Mahesh writes "Hi What's the universal date format in SQL which is accepted everywhere irrespective of the region its in. As i was inserting a mm/dd/yyyy format in India, it didn't worked in UK.Any helpMahesh" |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-01-02 : 01:59:59
|
| i think the default settings in Sql server for the dateformat isYYYY-MM-DD Whatever might be the settings if you are adding something this explicity '01-Jan-2002' , i think Sql server understands it and takes it correctly.Anywayz ,you can always use Cast function to format the date the way you want .HTH----------------------------Anything which Doesn't Kills you Makes you StrongerEdited by - Nazim on 01/02/2002 02:01:49 |
 |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-01-02 : 08:57:15
|
| The format, recognized by SQL Servers everywhere is the ISO format: yyyymmdd |
|
|
|
|
|
|
Date formats