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

Re: Insert date into Oracle

From: paddy_nyr <mpprpp_at_yahoo.com>
Date: Fri, 21 May 2004 15:11:24 -0400
Message-ID: <2h72blF9qr6rU1@uni-berlin.de>

"Allan" <dragon19993_at_yahoo.com> wrote in message news:b93d704b.0405211051.73462822_at_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
>

If your going to be using the current date then use 'sysdate' and that will get you both date and time. Received on Fri May 21 2004 - 14:11:24 CDT

Original text of this message

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