Print Page - urgent calulation needed folks

Title: urgent calulation needed folks
Post by: krishdw85 on 18 Dec 2010 04:35:09 AM

Hi folks
how can i convert timestamp into number?????

yyyymmdd hh:mm:ss:mil to number format i.e., yyyymmddhhmmss

thanks in adv

Title: Re: urgent calulation needed folks
Post by: jahnavi on 20 Dec 2010 05:28:57 AM

Hi,

Extract the hours,minutes,seconds and concatenate to get the result

extract(hours,[dataitem1]||extract(minutes,[dataitem1])||extract(seconds,[dataitem1])

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: krishdw85 on 18 Dec 2010 04:35:09 AM