Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
thinkman
Starting Member
1 Post |
 Posted - 2009-08-13 : 13:03:18
|
| Hi all the SQL experts out there, I am a newbie looking for some help. (please dont' laugh at my questions... :p)I am trying to insert some data into a table store in an Oracle database server by using Oracle SQL DeveloperINSERT INTO retail_channel (EVENTTIME)VALUES ('2009-01-28 07:14:13);I am getting this error msg: An error was encountered performing the requested operation:ORA-01861: literal does not match format string.This is the table struture:CREATE TABLE "RETAIL_CHANNEL" ( "LOCATIONID" VARCHAR2(20 BYTE), "EVENTTIME" DATE, ...................................If I exclude the time, then it works fine. However, it's crucial for me to include the time. Please advise, and thank you all in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
ORA-01861: literal does not match format string