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 - 2003-10-10 : 07:51:53
|
| NORA writes "Hallo, I tried to Convert date from one Database to SQL-Database and I got the following:Server: Nachr.-Nr. 170, False Syntax in der Nähe von '" + "'.cann you tell me please what to do to get date converter without syntax?Thanks, Nora" |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2003-10-10 : 08:25:48
|
| Tip:I have had better luck in dealing with Date transfers from other databases if I bring them over in Varchar and then run a S.P. to Convert them in SQL.JimUsers <> Logic |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2003-10-13 : 02:28:04
|
| And to avoid multi-national date appearance formatting issues, export and import them in YYYYMMDD layout.--------------------------------------------------------Visit the SQLTeam Weblogs at [url]http://weblogs.sqlteam.com[/url] |
|
|
|
|
|
|
SQL date Vonverter