Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Date Time insert
try the function to_date, like
to_date('10-DEC-1998 12:34:45, 'DD-MON-YYYY HH24:MI:SS')
If you only specify a string, Oracle thinks you only want to specify the date part and is supprised to find anything after the year you supplied, which result in suprise-01830. The date format picture Oracle thought of was DD-MON-YYYY. Hope this helps
Jac.
Tom Tamulewicz wrote in message <3655CA07.EDE5263E_at_4sighttech.com.nospam>...
>This seems really simple but I haven't been able to crack it yet:
>
>I need to insert a date with a time component. I've tried variations on
>my date representation, but always get the ORA-01830 error. As an
>example, I tried the date '10-DEC-1998 12:34:45'. I'm executing this
>through JDBC and would like to make it as reusable as possible. I
>haven't run across a standard date/time format the works.
>
>TIA,
>
>Tom
>
>
>
>ORA-01830: date format picture ends before converting entire input
>string
>
>
Received on Fri Nov 20 1998 - 15:41:23 CST