Geeks With Blogs

Arthur Zubarev Compudicted

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::TimeInSeconds] / 3600),3) + ":" + RIGHT("00" + (DT_WSTR,2)((@[User::TimeInSeconds] % 3600) / 60),2) + ":" + RIGHT("00" + (DT_WSTR,2)(@[User::TimeInSeconds]% 60),2)
Enjoy when handy! Posted on Wednesday, October 7, 2015 4:47 PM | Back to top

Comments on this post: SSIS Expression – Convert Seconds to HHH:MM:SS Format

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © Compudicted | Powered by: