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 |
|
rajeshverma
Starting Member
1 Post |
 Posted - 2010-07-19 : 00:26:34
|
| Hi Team,I am using SQL 2005. There, we created one SQL Linked Sever to read the text file using Jet OLEDB provider 4.0 . The issue is : there is a date column in the text file which is formated as dd/mm/yyyy . But when the linked server read the text file , it become mm/dd/yyyy . Pls advise me how could i do it. Appreciate any of your advice.Thanks. |
|
|
naveengopinathasari
Yak Posting Veteran
60 Posts |
Posted - 2010-07-19 : 01:39:16
|
| Convert the Date to mm/dd/yyyy in the linked server call.Lets unLearn |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-07-19 : 08:05:14
|
| Check CONVERT in SQL Server Books Online - there are some useful gridsJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-07-19 : 08:58:21
|
| use set dateformat dmy--your queryMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Linked Sever.