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