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 -> Insert date into Oracle

Insert date into Oracle

From: Allan <dragon19993_at_yahoo.com>
Date: 21 May 2004 11:51:07 -0700
Message-ID: <b93d704b.0405211051.73462822@posting.google.com>


Here is my SQL Statement:

insert into AD.aracct_range (acct_range, acct_range_desc, login, log_date, log_time)
values ('b', 'not applicable', 'wang', to_date('05/21/2004', 'mm/dd/yyyy'), '14:24');

Is that any possible to insert date without using to_date function. Because my application currently migrate from Unify database to Oracle.

Thanks in Advance

Alan Received on Fri May 21 2004 - 13:51:07 CDT

Original text of this message

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