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 |
|
jepatte
Starting Member
5 Posts |
 Posted - 2005-08-23 : 16:05:26
|
| When I look at my data through enterprise manager I see my datetime field data as ie. 7/2/2005 3:10:00 PM or 8/23/2005 5:31:00 AMI need to export this to a text file using the export wizard in Enterprise Manager. When I do this, my dates come out not in this format. How can I export it into this format? Eric |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-08-23 : 16:46:35
|
| In the Export wizard, when you pick the table that you are exporting, there is a Transform button where you can edit the transformation code using VBScript. The function would look something like... FormatDateTime(varDate, 0) where varDate is the reference to the source data field.---------------------------EmeraldCityDomains.com |
 |
|
|
|
|
|
datetime export to text