Convert Integer to Time in SSIS
I have the interger value 600 and would like to convert to 6:00:00 AM in my SSIS package. What date function performs this action???<$>
June 10th, 2011 5:18pm
It will be done by the following SSIS Expression:
SUBSTRING( @[User::StringVar], 1, 1 ) + ":" + SUBSTRING( @[User::StringVar], 2, 2 ) + ":00 AM"
There is no date in your integer!
Besides, you need to account for a case when the time is say 1200, right? If yes, then you need to check the value for length, hope you can do that yourself.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
June 10th, 2011 5:33pm
This topic is archived. No further replies will be accepted.
Other recent topics
