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

How to add one hour to a timestamp field??

Started by Sergio, 09 Jan 2008 09:59:05 AM

Previous topic - Next topic

Sergio

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!!!...

Northern_Monkey

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