Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01843

Re: ORA-01843

From: Tyler Smith Watu <watuni2000_at_yahoo.co.nz>
Date: 1 Apr 2004 11:59:33 -0800
Message-ID: <2f3438a4.0404011159.32b25d4b@posting.google.com>


Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1080787276.465493_at_yasure>...
> Tyler Smith Watu wrote:
>
> > I did try running both suggestions and still had
> >
> >
> > ERROR at line 1:
> > ORA-01843: not a valid month
> > ORA-06512: at "ORACLE.LONGTRANSPROC", line 3
> > ORA-06512: at line 1
> >
> > Maybe there is something else that I am missing
> >
> > TY
>
> The solution is to look at what is being output.
>
> Try it without casting to a DATE data type and see what
> is actually there.

A cast is necessary for the query to achieve the desired purpose Without a cast though the format of start_time was like DD/MM/YY

Thanks for all the responses

TY Received on Thu Apr 01 2004 - 13:59:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US