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 - 2001-11-18 : 11:14:43
|
| Alicia Perry writes "I am currently working on a project in which I need to import a text file into SQL Server 7. And one of the columns is in the following format:20011003T153103I need to convert this data (prior to being imported) into a datetime format that SQL Server will like.I have created a temporary table and set the target field to:Name:SessionStartDateTime datetime 8How would I code my DTS Import Function so that it will convert the import string to a datetime format?Thanks for your help!Alicia Perry" |
|
|
|
|
|
Converting a Text String to Date Format in DTS