Date format between oracle & crystal reports

[infodbases]

I am manipulating date format in pl/sql and trying to getdata for those dates by passing parameters.pl/sql is executes perfectly in oracle environment but when I call that procedure in Crystal 9 environment I am getting error like date should not be 0 or value mismatch

 

[pelajhia]

What is the exact error you are getting?

 

[lyanch]

You haven't mentioned your date type.. Crystal does not handle timestamps correctly...

Lisa

 

[synapsevampire]

Lisa: What problem does Crystal have with timestamps, I know about the timestamps with timezones concern.

-k

 

[lyanch]

In 8.5 (with maybe not the latest but close) native drivers. Timestamps come across as 6 char strings (blank). I have to convert them to date (in SQL expression) before using them in a report. On one test with ODBC use of a timestamp field caused crystal to crash.

Lisa