COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: t0mato on 26 Jul 2021 05:35:25 PM

Title: Remove Hour From Current_Timestamp
Post by: t0mato on 26 Jul 2021 05:35:25 PM
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!
Title: Re: Remove Hour From Current_Timestamp
Post by: t0mato on 26 Jul 2021 05:39:49 PM
Nevermind! This works: _add_hours ((current_timestamp),-1)