Oracle date columns

[Arthur Kogan]

Hi Allen,

I do not think you can do this (at all or at least easily) in Powerhouse.

Why not store date and time in 2 different fields. That is what we do on
VMS/RMS, storing the value of SYSDATE in DATE_MODIFIED field and the value of
SYSTIME in TIME_MODIFIED field. Both fields are defined as numeric, no Y2K
issues.

You can use Oracle triggers and stored procedures from Powerhouse, but why would
you bother. I would only do something like this if my database was
accessed/modified by something other than Powerhouse as well as Powerhouse and
this other product absolutely required datetime datatypes. Note that this
approach reduces the portability of your code.

Regards,

Arthur Kogan
Westpac Financial Services
Sydney, Australia

Jones Allen (Van) wrote:

> 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.



= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.