Re: ORACLE Date to C

From: Byron Pearce <bpearc1_at_abacus.tis.tandy.com>
Date: 1995/03/31
Message-ID: <3lh41m$a4k_at_abacus.tis.tandy.com>#1/1

Russell Dickerson (dickerso_at_gomez.stortek.com) wrote:
: Does anyone have words of wisdom for getting/putting a timestamp from/info
: my Oracle database? I am using Pro*C. The manuals are not very clear on
: how this works. I would love to be able to use the UNIX time_t (long)
: to do this.

Use the TO_CHAR function when SELECTing a DATE from the database and into a host variable. Use TO_DATE when INSERTing or UPDATEing a host variable into the database. Check the SQL Reference manual for details on this.

---

Byron Pearce                        |  The thoughts and views herein do not
Tandy Information Services          |  necessarily reflect that of Tandy
byron.pearce_at_tandy.com              |  Corporation.
------------------------------------------------------------------------------

"It's hard to be a ninja when you wear a beeper."

---

Received on Fri Mar 31 1995 - 00:00:00 CEST