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: Oracle Date Time insert

Re: Oracle Date Time insert

From: Jac. _at_ xs4all <_at_>
Date: Fri, 20 Nov 1998 22:41:23 +0100
Message-ID: <734nkm$ktj$1@news2.xs4all.nl>


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

Original text of this message

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