urgent calulation needed folks

[krishdw85]

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

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

thanks in adv

[jahnavi]

Hi,

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

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