Detecting the INSERT format for DATE database fields?
From: Thomas Jerkins <tomjerk_at_hotmail.com>
Date: Sat, 22 Jan 2005 09:37:04 +0100
Message-ID: <cst3bg$osr$05$1_at_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?
Date: Sat, 22 Jan 2005 09:37:04 +0100
Message-ID: <cst3bg$osr$05$1_at_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 Received on Sat Jan 22 2005 - 09:37:04 CET