SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-23-2008, 08:31 AM
| ||||
| ||||
 Re: ORA-01843 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. -- Daniel Morgan http://www.outreach.washington.edu/e...ad/oad_crs.asp http://www.outreach.washington.edu/e...oa/aoa_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply)      |
|
02-23-2008, 08:33 AM
| ||||
| ||||
| Re: ORA-01843 Daniel Morgan <damorgan@x.washington.edu> wrote in message news:<1080787276.465493@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 |
Linear Mode
