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 |
|
sqlsaravanan
Starting Member
3 Posts |
 Posted - 2008-01-07 : 04:08:31
|
| My control panel date setting is US format mm/dd/yyyy. But, the text file date format is dd/mm/yyyy. How do I upload the date correctly to Sql table from text file?At currently due to this conflict the dates are not correctly uploaded into SQL tablergds,Saravanan |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-07 : 23:20:01
|
| Try set date format before loading data:set dateformat dmy |
 |
|
|
sqlsaravanan
Starting Member
3 Posts |
Posted - 2008-01-09 : 03:59:18
|
| User wants to maintain dmy format in control panel due to other existing application requirement. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-09 : 05:34:09
|
| set dateformat only changes sql's format of date. so other existing applications would still use system date format. |
|
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2008-01-10 : 10:22:52
|
| are you using DTS? in activex you can use substrings and concatenation to format the date |
|
|
|
|
|
|
SQL server DTS task Date manipulation