Crystal Showing Date datatype as Datetime

[kutoose]

Database : Oracle 9i
Crystal Version : 10

I have a table in which there are fields with 'Date' datatype.

But while in 'field explorer' with 'Show field type' selected, Crystal is showing the data type as Datetime. Why is it so ?


kutoose@yahoo.com

 

[lbass]

Go to file->report options and see if the report is set to convert datetime field to datetime. Not sure if this is the problem, but it's worth a look.

-LB

 

[synapsevampire]

Could be a few things, certainly LB's suggestion is a quick fix if that's the case.

Otherwise it can be related to connectivity, such as using the Oracle ODBC instead of Crystal's native or ODBC connectivity.

A quick fix would be to use a SQL Expression or a Crystal formula to convert it and reference the formula, as in:

cdate({table.field})

or a SQL Expression might use a CAST or CONVERT statement, which would prove a bit faster as it's processed by the database.

-k