Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Question: Date Substitution on NULL fields

Re: SQL Question: Date Substitution on NULL fields

From: Dante A. Notari-Locher <dnotari_at_cso.at>
Date: 1997/08/08
Message-ID: <33EB13CA.79CEF5D@cso.at>#1/1

Hi David !

Try it with nvl !

select purchase_no, nvl(date,'00/00/00) ....

Best regards

Dante A. Notari-Locher Received on Fri Aug 08 1997 - 00:00:00 CDT

This message: [ Message body ]
Next message: Patrice LENOIR: "D2K & Oracle Object & VB4"
Previous message: Alexey E. Neckrasow: "Re: SQL Question: Date Substitution on NULL fields"
In reply to: David Sivick: "SQL Question: Date Substitution on NULL fields"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US