Oracle date columns

[Jones Allen (Van)]

Does anyone know a way to get both the date and time into an Oracle date
column in Powerhouse?  The Oracle "sysdate" function returns the date, with
the time represented as a fraction of a day.  A Powerhouse program filling
in the same column just provides the date portion.

I've tried defining a "d_date datetime = sysdate" in Quiz to see if, perhaps
Powerhouse's "datetime" datatype would work, but again, Powerhouse's
"sysdate" function doesn't return the time.  I've tried other approaches
such as moving a floating point value with a fractonal part to the datetime
field, but no.  I've also tried Powerhouse "decimaltime" function, but the
Quiz parser generates an error message for it, and doesn't recognize the
fiunction.

Qshow shows the Oracle column as a "datetime" data type.  Part of the
problem may be the Powerhouse dictionary's element definition for the column
(date), but I don't think that's the entire problem.

I'm using Oracle 7.3 on an HP-UX computer with Powerhouse version 7.33.D3.
Any ideas are welcome, and thanks for your time.

Allen Jones
VantagePoint Group
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.