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