CONVERT MILLINIUM SECONDS INTO HHMMSS IN FRAMEWORK MANAGER

[RP]

Hi,

Can any one tell me how to convert millennium seconds Into HHMMSS in Framework Manager..

same thing I'm getting thru sql query..
ie.  convert(VARCHAR, DATEADDED(MS,DATETIME FILED, 0),114) FROM TABLE..
So I NEED TO DO IN FRAMEWORK MANAGER, THERE IS NO 'CONVERT' FUNCTION IN FRAMEWORK MANAGER, CAN ANY ONE HELP ME ON THIS...

THANKS IN ADVANCE..

[tupac_rd]

http://www-01.ibm.com/support/docview.wss?rs=3442&context=SS9RTN&q1=%2bconvert&uid=swg21341932&loc=en_US&cs=utf-8&cc=us&lang=all

is this what you are looking for...

or this?

http://www-01.ibm.com/support/docview.wss?rs=3442&context=SS9RTN&q1=%2bconvert&uid=swg21339594&loc=en_US&cs=utf-8&cc=us&lang=all