Re: Insert date into Oracle

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 - 08:54:44 CDT