Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: RP on 25 Aug 2010 04:23:46 AM

Title: CONVERT MILLINIUM SECONDS INTO HHMMSS IN FRAMEWORK MANAGER
Post by: RP on 25 Aug 2010 04:23:46 AM
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..
Title: Re: CONVERT MILLINIUM SECONDS INTO HHMMSS IN FRAMEWORK MANAGER
Post by: tupac_rd on 25 Aug 2010 08:51:44 AM
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
Text only | Text with Images