Inserting a record with a Date field

[doehnhe]

Every time when I try to update or insert a record with a date field to a oracle table, there is the following error message: "ORA-01843 month not guilty".
How have I to set the date (24-12-2000 10:00:00, 12/24/2000 10:00:00, 24.12.2000 10:00:00, ....) and where have I to set the time format for Germany?

 

[Helene]

The easiest way is to use the to_Date function specifying the date format you use in it. E.g. to_date ('01-01-2000 23:00','dd-mm-yyyy hh24:mi'). Or, if you do this from a DOA Component you should rather use bind variables to set the date.