Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQL insert date ?

SQL insert date ?

From: Scott Andrew Wehrmann <swehrman_at_phoenix.csc.calpoly.edu>
Date: 30 May 1998 03:18:07 -0700
Message-ID: <6komcv$718@phoenix.csc.calpoly.edu>


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.

Received on Sat May 30 1998 - 05:18:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US