Print Page - Modify the Date Timestamp in Cognos?

Title: Modify the Date Timestamp in Cognos?
Post by: razsekhar on 25 May 2010 04:06:41 AM

I have one report in which for the date column some records have timestamp and some dont have timestamp cognos by default shows 12:00:00 when there is no timezone,so my requirement is to remove the 12:00:00 that cognos shows inthe report,any idea how to remove that.

Title: Re: Modify the Date Timestamp in Cognos?
Post by: tupac_rd on 25 May 2010 10:15:42 AM

cast ( [date column', date) would work I believe...

Title: Re: Modify the Date Timestamp in Cognos?
Post by: mvjcognos on 24 Jun 2010 02:39:58 AM

Try this function to_date(sysdate,'yyyymmdd') this will show without
timestamp...........

Title: How to set Default selection as ALL in value prompt ?
Post by: sharatv on 27 Jul 2010 07:57:48 AM

I have one report in which for the product prompt column i want to set the default display option as All when i open the report.can anyone have the script for this plssss...

Title: Re: Modify the Date Timestamp in Cognos?
Post by: tupac_rd on 27 Jul 2010 10:31:44 AM

http://www-01.ibm.com/support/docview.wss?rs=3442&context=SS9RTN&q1=%2b%27Select+%2ball%27&uid=swg21339895&loc=en_US&cs=utf-8&cc=us&lang=all

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: razsekhar on 25 May 2010 04:06:41 AM