Home » SQL & PL/SQL » SQL & PL/SQL » to_char help
to_char help [message #10209] Thu, 08 January 2004 15:09 Go to next message
Laura T
Messages: 1
Registered: January 2004
Junior Member
I am trying to insert a row into my Oracle database and I receive a message saying that i am missing a comma...can you look at my code and tell me what i am doing wrong or what i am missing?

insert into table values ('Test','A', to_date('01-jan-00 13:00:00','DD-Mon-YY hh24:mi:ss'), to_date('01-jan-00 20:00:00','DD-Mon-YY hh24:mi:ss');

Report message to a moderator

Re: to_char help [message #10211 is a reply to message #10209] Thu, 08 January 2004 18:17 Go to previous messageGo to next message
resy
Messages: 86
Registered: December 2003
Member
aren't u missing an end bracket??

Report message to a moderator

Re: to_char help [message #10212 is a reply to message #10209] Thu, 08 January 2004 18:19 Go to previous messageGo to next message
resy
Messages: 86
Registered: December 2003
Member
try this

insert into table values ('Test','A', to_date('01-jan-00 13:00:00','DD-Mon-YY hh24:mi:ss'), to_date('01-jan-00 20:00:00','DD-Mon-YY hh24:mi:ss'));

Report message to a moderator

Re: to_char help [message #10213 is a reply to message #10209] Thu, 08 January 2004 18:32 Go to previous message
S.Rajesh Kannan
Messages: 26
Registered: September 2003
Junior Member
Hi,

Properly close parenthesis ( Missing right parenthesis).

insert into table values (
'Test',
'A',
to_date('01-jan-00 13:00:00','DD-Mon-YY hh24:mi:ss'),
to_date('01-jan-00 20:00:00','DD-Mon-YY hh24:mi:ss')
);

Thanks & Regards
S.Rajesh Kannan

Report message to a moderator

Previous Topic: Urgent:Dropping a Table
Next Topic: create table error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 06:10:09 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.