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 |
|
vasu4us
Posting Yak Master
102 Posts |
 Posted - 2007-06-24 : 13:59:09
|
| hi all, i am trying to convert getdate()to yyyymmdd type of output using derived column transformation and this transformation doesnot recognise CONVERT function.this is what iam trying to do2007-01-01 00:00:00.000 to 20070101 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-06-24 : 14:30:53
|
normally it's best to simply return a datetime and handle presentation issues like this on the client.
elsasoft.org |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-06-24 : 15:26:34
|
| Try FORMAT as function for SSIS.Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
date transformation