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-02-14 : 18:35:13
|
Tony writes "I am about to transfer data from excel into SQL Server 2000. In excel there are columns holding date data in them - eg Data_Of_Booking etc.
I need to convert these data into the date datatype. At the moment SQL converts the data into its default datetime format 01/12/2001.00.00.00. How do I go about using the CONVERT() syntax whlist transfering the data using DTS?
What is the best possible way of doing this?
Please help.
Thanks
Ton" |
|
|
|
|
|
Data Conversion