COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: esanray on 14 Nov 2011 04:19:00 AM

Title: system time
Post by: esanray on 14 Nov 2011 04:19:00 AM
How to filter system time + 12 hours
Title: Re: system time
Post by: HalfBloodPrince on 14 Nov 2011 04:59:06 AM
You can use Systime() function for getting syatem time. But for adding +12 hours no direct function is available i guess.You have to conver it into minutes +add minutes (12*60) and then again convert it in to time.
Title: Re: system time
Post by: esanray on 18 Nov 2011 06:16:22 AM
Can you Please tell me the query to write