Re: Comparing "date" values in Pro*C

Pravin Sitaram (ink_at_tiac.net) wrote:
: Within a Pro*C program, I need to select "date" values
: from a database table. What is the data type that I
: need to define in "C" for the host variable so that
: I can extract the "date" value into the host variable
: and then compare two "date" values? I tried "char *"
: datatype for the host variable, but it does not work.

It's not so much the datatype as how you are doing the comparison, which will depend on the format that you are retrieveing the dates in.

Maybe you could retrieve as YYYYMMDD into numeric datatypes and then use the normal numeric operators ?

Easy enough to cater for hours, mins and secs as well.

IAP

--
In an attempt to reduce junk email I use an invalid 'From' address.
My correct email address can be determined by replacing 'not.valid' with 
'value.net'