alter session set.. (look in docs) Also could do it in a log on trigger.
Jim
"Alan" <wangxianlg_at_yahoo.com> wrote in message
news:18a6fc2f.0405241701.7a6877e3_at_posting.google.com...
> Thanks a lot.
>
> I am using alter session set nls_date_format= 'mm/dd/yyyy' and did
> insert value '05/24/2004' into date field without using to_date and
> sysdate function.
>
> I am just wondering how can I change NLS_DATE_FORMATE permanently. I
> did change init.ora file and restart the database but it does work.
>
> Thanks in advance
>
> Alan
>
> dragon19993_at_yahoo.com (Allan) wrote in message
news:<b93d704b.0405240711.5dd8ab59_at_posting.google.com>...
> > We have guy here knows how to modify the c++ code. The problem is we
> > don't want to do that. That's why I am asking is there any way around
> > this problem.
> >
> > Please give me some good advices...
> >
> > Thanks
> >
> > Alan
> >
> > Steve <ThisOne_at_Aint.valid> wrote in message
news:<c8s6op$e2i$1_at_lust.ihug.co.nz>...
> > > Allan wrote:
> > > > 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.
> > >
> > > Unlikely to be in C++ - I don't think it had been invented yet! (
Bjarne
> > > Sroustrup in the early 80's IIRC - hope I spelled his name right :)
> > >
> > > However, if you're looking for C developers who are also Oracle DBA's
to
> > > port your code...?
> > >
> > >
> > > Steve
Received on Mon May 24 2004 - 20:36:47 CDT
