Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Insert date into Oracle

Re: Insert date into Oracle

From: Ed Stevens <nospam_at_noway.nohow>
Date: Mon, 24 May 2004 11:06:15 -0500
Message-ID: <us64b09beiitbqhm8fl1h2t0sjsicr9iu3@4ax.com>


Reply embedded . . .

On 24 May 2004 08:11:23 -0700, dragon19993_at_yahoo.com (Allan) wrote:

>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.
>

I just remodeled my kitchen. Replaced the old wood-burning stove with a shiney new, ceramic-top electric wonder. But the new stove requries a 240-volt outlet, and the house was never wired for 240. In fact, even the 120 wireing is being pushed to its limit. I can't run the window fan and toaster at the same time without blowing a fuse. I have an electrictian who knows how to do the wireing, but we don't want to do that. Is there another way around the problem?

>Please give me some good advices...
>

You've been given good advice. Modify the code.

>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 - 11:06:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US