Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to insert date with time into Date type without to_date and to_char

720067May 7 2010 — edited May 7 2010
Hey,

I have DATE type column.

I can do sth like that
insert into table (column) values ('2003/05/03') - and it works

can I insert sth with time in this way?

for example:
insert into table (column) values ('2003/05/03 12:12') - it doesn't work
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 4 2010
Added on May 7 2010
7 comments
63,042 views