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

Remove Hour From Current_Timestamp

Started by t0mato, 26 Jul 2021 05:35:25 PM

Previous topic - Next topic

t0mato

Hello,

My database's timezone is an hour ahead. I'm looking to show an accurate report run time in the header of my report. Currently, i've created a query to return (current_timestamp), however, it is 1 hour ahead. Is there a way to subtract/minus 1 hour from the report timestamp? How would the expression need to be written?

Thanks!

t0mato

Nevermind! This works: _add_hours ((current_timestamp),-1)