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

Home -> Community -> Usenet -> c.d.o.server -> Re: Date Insert Problem

Re: Date Insert Problem

From: SteveC <stevec_at_sfsu.edu>
Date: 6 Feb 2006 15:21:08 -0800
Message-ID: <1139268068.464629.224750@z14g2000cwz.googlegroups.com>


Maybe he WAS reading the documentation, and missed the fact that if you use the ANSI date function, you must include the word "date":

insert into foo (foodate) values(date'2005-08-19'); Received on Mon Feb 06 2006 - 17:21:08 CST

Original text of this message

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