If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

extract function in reportnet

Started by uyravikumar, 28 Jul 2006 03:32:34 AM

Previous topic - Next topic

uyravikumar

Hi All,

I am working on a project, i have problem with extract function.

I need to display the Hours:Minutes:Seconds of difference from two dates which is placed in on data item [TIMEDIFF].

I used
CAST(EXTRACT(HOUR,[TIMEDIFF]),VARCHAR(2))||':'||
CAST(EXTRACT(MINUTE,[TIMEDIFF]),VARCHAR(2))||':'||
CAST(EXTRACT(SECOND,[TIMEDIFF]),VARCHAR(2))


The output is 0:34:14. (OR) 0:33:23.3

I want to get the second part as Integer.

Can any body help me..

Thanks in advance

MFGF

Hmmm - deja vu.  Must be a glitch in the matrix!

Please see my previous reply to the same question.
Meep!