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 - 2002-12-26 : 10:41:48
|
| Kevin writes "We are Windows 2000 SP3 with SQL 2000. We are trying to export SQL table to a CSV file format. All is working execept for the Date Fields, when exported they are including the time stamp as well. Format for the fields is Date/Time.We need to get the info from SQL into a date only formatTHanks" |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2002-12-26 : 10:56:39
|
| use the convert function and convert your date into a varchar field and use format 110. Check out CAST and CONVERT in BOL for an example. This will allow you to drop the time format off of the date.Mike"oh, that monkey is going to pay" |
 |
|
|
|
|
|
Export with Date/Time