Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> SQL insert date ?
If I have a table that is declared as,
create table info (
currentdate date
)
How do I insert a date that looks like '1998-06-19 17:00:00.0'? Do I
have to use the to_date function, or is there a way I can just insert
the date?
I've tried insert into info values ('1998-06-19 17:00:00.0'), but it
gives me an error. Thanks for any suggestions.