Crystal report oracle date question

Question

0.00/5 (No votes)

See more:

Hi all, I have a Crystal Report which uses an Oracle database, one of the date columns is displaying 31-Dec-4000, I've checked the data with an Oracle IDE and the latest date in this column is 31-Dec-2017 so don't understand why I'm seeing this - any ideas ?

Edit

I've identified the dates that are showing the year 4000

31-AUG-00
31-DEC-00
30-DEC-00

Edit 2

I've looked at the data in SQL Developer now and that too shows the year as 4000 for the above dates

What I have tried:

Checked the data with an Oracle IDE and the latest date in this column is 31-Dec-2017

Posted 24-Oct-16 21:34pm

pkfox

Updated 24-Oct-16 22:49pm

v3

Add a Solution

Comments

Jörgen Andersson 25-Oct-16 4:46am

Sounds like a conversion problem to me.
What datatype is the date column, is it Date?
Is there any business layer between CR and DB or is CR accessing the DB directly?

pkfox 25-Oct-16 4:51am

Yes it's date and using default Oracle driver to connect it with CR, see my amended question

Kornfeld Eliyahu Peter 25-Oct-16 5:01am

What are you saying that every 00 year (2000?) shows as 4000?

pkfox 25-Oct-16 5:16am

Apologies to everyone the client I'm currently contracting for has just told me he set all of the records to 31-12-4000 ( it's and end date for a loan ) so that explains it - apols once more

Kornfeld Eliyahu Peter 25-Oct-16 5:22am

Ah... you have a CLIENT!

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)