Oracle 10g date issues

[lunchbox88]

Crystal Reports XI
Oracle 10g

I'm writing a report that is supposed to show how much time it took to go from one status to another. Not a big deal.

My issue is that Crystal is only displaying the date, not datetime. If I query the db using WinSQL, it shows datetime. If I query the db using SQL+, it only shows date.

What do I need to do to get the datetime in Crystal instead of just the date?

 

[synapsevampire]

Tou need to determine the actual date type in Oracle, it may be that it's one of the newer date types, such as date with timezone, in which case Crystal may not see it correctly.

Also you need to state how you are connecting to the database (Native, Oracel supplied ODBC, Crystal supplied ODBC, or?).

You should use the Native connectivity, and you might even need a SQL Expression to CAST it to a datetime.

-k

 

[lunchbox88]

I'm assuming by "Native" you mean using the MS driver for Oracle?

I've been using the Crystal Oracle driver because using the MS supplied causes Crystal to only show stored procs, and not db's.

 

[lunchbox88]

Umm...nevermind. Figured it out. New baby...brain is mush.