Modify the Date Timestamp in Cognos?

[razsekhar]

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.

[tupac_rd]

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

[mvjcognos]

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

[sharatv]

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

[tupac_rd]

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