Print Page - How to add one hour to a timestamp field??

Title: How to add one hour to a timestamp field??
Post by: Sergio on 09 Jan 2008 09:59:05 AM

Hi!!..
i would like to add one hour to a timestamp field. F.e., the field show 2008-08-21.08:21:30, and the user wants to see one hour more (2008-08-21.09:21:30), because he has a problem with it field in his database. How i can add it???....over the report or in the FM Model..???
Thanks a lot!!!...

Title: Re: How to add one hour to a timestamp field??
Post by: Northern_Monkey on 28 Sep 2009 07:48:37 AM

If you are using a SQL backend, use the dateadd function

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Sergio on 09 Jan 2008 09:59:05 AM