| Insertion error [message #647794] |
Mon, 08 February 2016 04:02  |
snsiddiqui
Messages: 172
Registered: December 2008
|
Senior Member |
|
|
I am facing below error in the simple insert statement, kindly resolve.
ERROR at line 1:
ORA-00917: missing comma
Insert into setups_setup(id,code,type,descr,to_date(entdate,'dd-mon-yyyy hh24:mi:ss'))
values ('55','07','ISITE','sdfsd','08-Feb-2016 02:56:57')
|
|
|
|
|
|
|
|
|
|
| Re: Insertion error [message #647804 is a reply to message #647800] |
Mon, 08 February 2016 10:01  |
Bill B
Messages: 1971
Registered: December 2004
|
Senior Member |
|
|
As they noted, change it to
Insert into setups_setup(id,code,type,descr,entdate)
values ('55','07','ISITE','sdfsd',to_date('08-Feb-2016 02:56:57','dd-mon-yyyy hh24:mi:ss'))
|
|
|
|
| Re: Insertion error [message #647814 is a reply to message #647794] |
Tue, 09 February 2016 02:28 |
 |
msol25
Messages: 396
Registered: June 2011
|
Senior Member |
|
|
Dear,
This is very Basic Question.
INSERT INTO setups_setup
( id
,code
,type
,descr
,entdate
)
VALUES
( '55'
,'07'
,'ISITE'
,'sdfsd'
,TO_DATE('08-Feb-2016 02:56:57','DD-Mon-YYYY HH24:MI:SS')
);
|
|
|
|
| Re: Insertion error [message #647815 is a reply to message #647814] |
Tue, 09 February 2016 02:40 |
 |
Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Hopefully you are there to repeat what has already been suggested AND specified.
What does your post add to Bill's one?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
