In article <8bv3v6$ebc$1_at_news2.isdnet.net>,
"Ed" <possum_at_ois.com.au> wrote:
> It is about storing Time in a date field
>
> ie
> {This does work}
> insert into TableX (DATEX) VALUES ('30-Mar-2000')
> ----------------------------------------------------------
>
> {This does not Work}
> insert into TableX (DATEX) VALUES ('30-Mar-2000 10:29:59')
>
Try : > insert into TableX (DATEX) VALUES (to_date('30-Mar-2000
10:29:59', 'DD-MON-YYYY HH24:MI:SS'))
> Vb says :
> [ORA-01858: a non-numeric chacter was found where a numeric was
expected]
>
> Sql*Plus Worksheet says:
> [ORA-01830: date format picture ends before converting entire input
string]
>
> ----------------------------------------------------------------------
>
> We are enabling our SQL app to also work for Oracle.
> We had an Oracle DBA bring our SQL DB across to Oracle.
> Anybody know what has happened here ?
> We looked at the data types available with in the table and there is
only
> one date type
> available to us. [DATE]. {go figure}
>
> Much appreciated
> Ed.
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Mar 30 2000 - 03:46:54 CST
