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 |
|
dougancil2009
Starting Member
17 Posts |
 Posted - 2010-05-18 : 10:58:57
|
| I have the following SQL Bulk Insert in my asp.net page: Dim sqlQueryText As String = _ "BULK INSERT dialerresults " + _ "FROM '" & SavePath & "' " + _ "WITH ( FIELDTERMINATOR = ',' , ROWTERMINATOR = '\n' )"and I have the following data set:,512 408 1323,steve miller,doctor stevens,20100709 1:30, 20100709 1:30,,what I need to do is to convert the two datetime fields to have the first one just date and the second one just time. I'm using SQL 2000 and just need to know the correct syntax to put that in with SQL that will work with my asp.net page.Can anyone assist? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-18 : 14:13:16
|
| you have to convert them to varchar if you want only date or timepart alone------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
SQL Cast and convert