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 |
|
pmccann1
Posting Yak Master
107 Posts |
 Posted - 2007-11-23 : 08:07:43
|
| i am using enterprise manager to create a csv file from sql table. when i do this the date 11/11/2007 gets changed to 11/11/2007 00:00 is there a way of stoping it adding the time bit |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-11-23 : 08:40:13
|
| select Convert(varchar(10),getdate())look up convert for further options. |
 |
|
|
pmccann1
Posting Yak Master
107 Posts |
Posted - 2007-11-23 : 08:55:38
|
| so i will ahve to do in from analyser side not enterprise manager |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-11-23 : 09:00:02
|
| Yes, in SQL there is no date there is only datetime. |
|
|
|
|
|
|
format issue when exporting