Geeks With Blogs

Arthur Zubarev Compudicted October 2015 Entries
SSIS Expression – Convert Seconds to HHH:MM:SS Format
It is a SSIS developer snack. Today on the MSDN Forums I came across a post in which a person asked for help converting an arbitrary number seconds to HH:MM:SS format. I quickly reached out to my SSIS Expression Editor and Tester where I store any helpful SSIS expressions I developed or came across. After posting my reply back I decided to share it online, so without further ado it is: RIGHT("000" + (DT_WSTR,3)(@[User::TimeInS... / 3600),3) + ":" + RIGHT("00" + (DT_WSTR,2)((@[User::TimeIn... ......

Posted On Wednesday, October 7, 2015 4:47 PM

Copyright © Compudicted | Powered by: