"Thomas Jerkins" <tomjerk@hotmail.com> a écrit dans le message de
news:cst3bg$osr$05$1@news.t-online.com...
| Assume I got a database resp. table defintion with a DATE field. How do I find out in which format
the
| field should be filled in an INSERT SQL statement?
|
| Sometimes when I enter e.g.
|
| INSERT INTO .... VALUES (....., '2005-01-25',.....);
| or
| INSERT INTO .... VALUES (....., '2005-01-25-13.14.15.00',.......);
|
| I got an error like:
|
| ORA-01861: literal does not match format string
|
| before I realized that
|
| INSERT INTO .... VALUES (....., '25-01-2005',....);
|
| is the correct format.
|
| Tom
|

Never rely on implicit conversion.
Use to_date to explicitly convert your external format to date datatype:
insert into ... values (..., to_date('2005-01-25','YYYY-MM-DD'),...);
or
insert into ... values (..., to_date('2005-01-25-13.14.15.00','YYYY-MM-DD-HH24.MI.SS.FF2'),...);
or whatever is your external format.
This is the correct way.

Regards
Michel Cadot