Re: Dates in OCI

I know that Oracle stores date/times as 7 bytes (4 for the date and 3 for the time). But in ODBC, I think I can call SQLBindParameter() and pass it SQL_DATE and a DATE_STRUCTURE or SQL_TIME and a TIME_STRUCTURE, and store only the date or time in a column of type DATE. In fact, I'm pretty sure I've seen this done before.

But after speaking with some well knowledged people, everybody keeps telling me that Oracle stores it as date/time.

huh <huhhy_at_rocketmail.com> wrote in message news:7rsus3$i7g$2_at_ns.felk.cvut.cz...
> Edward,
>
> I'm afraid, neither ODBC nor OCI gives you the information you want.
> ORACLE datatype DATE is mapped in ODBC to SQL_TIMESTAMP.
> Both interfaces can't give you this information, because neither of them
> have any knowledge what was you db designer's intention when (s)he
> chose the DATE datatype.
>
> --
> Thank you for keeping >anti-spam< habit:
> not including my address in your reply.
>
>
Received on Fri Sep 17 1999 - 21:18:49 CDT