Re: Insert date into Oracle

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 - 10:11:23 CDT