467,210 Members | 1,194 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,210 developers. It's quick & easy.

Detecting the INSERT format for DATE database fields?

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

Jul 19 '05 #1
  • viewed: 5079
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

15 posts views Thread by Simon Brooke | last post: by
20 posts views Thread by akej via SQLMonster.com | last post: by
reply views Thread by Thomas Jerkins | last post: by
11 posts views Thread by Ted | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.