Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Insert date into Oracle
Yes, You would set the nls_date format. However, this is prone to error
since someone could change it on their system without your knowledge. You
could do an alter session (you would have to change the application or
create a logon trigger) and that would minimize the potential that someone
changes an env. variable on the client machine.
Jim
"Allan" <dragon19993_at_yahoo.com> wrote in message
news:b93d704b.0405230554.706c3fe2_at_posting.google.com...
> Thanks for your reply.
>
> I think I didn't make myself clear. We have a application which has
> been used for 30 years and now we want to move from Unify database
> into Oracle and also we don't want to change the application code.
>
> Problem is that the application is wrriten by c++ and get the date
> from OS. But now in order to insert the date into Oracle, we have to
> use to_date function to convert the date.
>
> I am just wondering if there is another way around to insert date into
> Oracle without using to_date function and sysdate function. that way
> we don't need modify our c++ code for application.
>
> Thanks in advance
>
> Alan
>
>
> "paddy_nyr" <mpprpp_at_yahoo.com> wrote in message
news:<2h72blF9qr6rU1_at_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 Sun May 23 2004 - 10:04:18 CDT