Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Insert date into Oracle
"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