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 |
|
lols
Posting Yak Master
174 Posts |
 Posted - 2007-09-24 : 07:34:28
|
| Hi,I am moving a file to another folder after processing. I want to append the month, year and time. I have been able to append yr and month using this(DT_STR, 2, 1252) Month( @[System::StartTime] )+ (DT_STR, 4, 1252) Year( @[System::StartTime] )How to append the time to this?thanks |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-09-24 : 08:18:27
|
| Try(DT_STR, 2, 1252) Month( @[System::StartTime] )+ (DT_STR, 4, 1252) Year( @[System::StartTime] )+convert(varchar(20),@[System::StartTime] ,108)MadhivananFailing to plan is Planning to fail |
 |
|
|
lols
Posting Yak Master
174 Posts |
Posted - 2007-09-24 : 10:10:33
|
| thanks. |
|
|
|
lols
Posting Yak Master
174 Posts |
|
|
|
|
|
Add timestamp to the file