Converting datetime into date for ODBC datasource

[s.aravindkumar]

Hi,

I am using cognos report studio and
I have used Optim(IBM Product) archive file as a datasource which will connecting to cognos through Open data manager/ODM(IBM Product).
In database I have the data as 11-NOV-98 but in ODM its showing as Nov 11, 2010 12:56:34 so in cognos also its showing same as ODM.

So to convert the date time to date I was trying Cast but that is not working so can someone suggest how to convert datetime into date ?

Thanks and Regards,

Aravind Kumar Sekar

[MFGF]

...So to convert the date time to date I was trying Cast but that is not working so can someone suggest how to convert datetime into date ?

Hi,

Can you tell us what "that is not working" actually means? Do you get an error? An incorrect result? No result? Something else? Can you provide details?

What exact syntax did you use for your Cast expression?

MF.

[BigChris]

cast([Your DateTime Field], date) should do the job for you