Date Display.

[David Heasman]

> We are using Oracle with a Powerhouse application that disallows nulls.
> Powerhouse programs will let us enter "zero" dates, but Oracle's SQL
> commands won't:  after all, zero is not a valid date.  In SQL select
> statements, Oracle does it's best to interpret the resulting bit-pattern
> (or whatever it is) as a date, but it's not a real date and neither is
> it null.


We find that the SQL expression : -

 IF TO_CHAR(p_date_in,'DD-MON-YYYY')='00-DECEMBER-0000' THEN

returns a TRUE value if presented with a PowerHouse zero date.

We use Oracle 7.32 on HPUX 10.something.

Your mileage may vary.

Dave



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