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

Best way to get last 2 hour in report studio

Started by priya1988nath, 21 Mar 2018 04:25:51 PM

Previous topic - Next topic

priya1988nath

Hi all ,
I am using audit database to check what are reports failed in last 2 hours.I have used extract hour for this .But not satisfied with this code .Can you please let me know the best way to subtract 2 hours from  time stamp field?
I have already tried add_hour also . but it didn't worked out

sdf

did you cast your add_hour to timestamp???