Re: Date Format Picture?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/10/07
Message-ID: <343d6660.11746801@newshost>#1/1

On Tue, 07 Oct 1997 10:29:51 -0500, Cherie Machler <n32cmn_at_is.nwa.com> wrote:

>Our users are getting an ORA-1830 error from a third-party
>vendor app.
>
>The error text says date format picture ends before converting entire
>input string. I looked the error up and read the Cause and Action.
>Cause: A valid date format picture included extra data. The first
>part of the format picture was converted into a valid date, but the
>remaining data was not required.
>Action: Check the specifications for date format pictures and
>correct the statement.
>
>My question is: What does the word picture mean in this context?
>I can not find reference to a date format picture in my manuals.
>I'm unsure how to explain this to our users as I don't really
>understand the phrase data format picture.
>

Here is an example:

select to_date( '01-JAN-97 12:00:00', 'DD-MON-YY' ) from dual

                *

ERROR at line 1:
ORA-01830: date format picture ends before converting entire input string    

The date I input, 01-JAN-97 12:00:00, is the input data.

The date format picture is 'DD-MON-YY' which is 2 digit day followed by - followed by three character month followed by - followed by 2 digit year.

In my case, the date I entered is too long for the date format picture. The date formate picture ended before the input data ended -- hence the error.

Hope this helps.

>Can anybody shed any light on this?
>
>Thanks in advance for your enlightenment.
>
>Cherie

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD

http://govt.us.oracle.com/ -- downloadable utilities

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Oct 07 1997 - 00:00:00 CDT