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: Similar Functions to Informix conversion functions dectoasc() and rfmtdate()

Re: Similar Functions to Informix conversion functions dectoasc() and rfmtdate()

From: Lawrence Simela <lsimela_at_mahalini.prestel.co.uk>
Date: Fri, 28 Sep 2001 19:07:57 +0100
Message-ID: <9p2m04$880$1@phys-ma.sol.co.uk>


It would be easier all round if you stated in ordinary language what it is that you wish to achieve rather than asking us to trawl through C code.

I mean asking for functions which do similar stuff to " dectoasc() and rfmtdate() in Informix". Those two functions mean nothing to me and I am sure the same goes for many here.

How about saying something like "Is the a function to convert a date to a long" etc..

lawrence

"BDargie" <wcdargie_at_statestreet.com> wrote in message news:f5673601.0109280818.76f33195_at_posting.google.com...
> In essence how do I do something like this in Oracle:
>
> void Convert_date_decimal(){
> int ret_code = 0;
>
> if ( ret_code = dectoasc( &temp_key2, t_key2, 16, 4)){
> t_key2[0] = '\0';
> }
> else {
> t_key2[16] = '\0';
> }
>
> if (ret_code = rfmtdate( temp_key3, "mm dd yyyy", t_key3)){
> t_key3[0] = '\0';
> }
> if ( ret_code = rfmtdate( temp_key4, "mm dd yyyy", t_key4)){
> t_key4[0] = '\0';
> }
> }
> /* end function convert_date_decimal() */
Received on Fri Sep 28 2001 - 13:07:57 CDT

Original text of this message

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