Re: ORACLE Date to C
From: Sarvesh Mathur <mathur_at_elaine18.Stanford.EDU>
Date: 1995/03/30
Message-ID: <3lf3dv$78g_at_nntp.Stanford.EDU>#1/1
Date: 1995/03/30
Message-ID: <3lf3dv$78g_at_nntp.Stanford.EDU>#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.
There is a function called sysdate which returns the current date/time as an oracle DATE type; You can use the TO_CHAR function to format the date value into a string of your chosen format.
Just check the info on page 3-33 of the SQL lang ref manual.
: Russell
: --
Received on Thu Mar 30 1995 - 00:00:00 CEST