Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8.0.5 and Date formats
try:
INSERT INTO MyTable (Name, Title, DateOfHire)
VALUES ('Jason', 'Programmer/Analyst', to_date('1998-07-05','YYYY-MM-DD')); Received on Wed Mar 03 1999 - 07:21:27 CST