Re: SQL Question: Date Substitution on NULL fields

From: AMARENDRA B NETTEM <nettama_at_charlie.cns.iit.edu>
Date: 1997/08/08
Message-ID: <33EB63FC.4AFF@charlie.cns.iit.edu>#1/1

Hi David,
Try this sql statement . It works

SELECT PURCHASE_NO,
       DECODE(DATE1, NULL,'00/00/00, TO_CHAR(DATE1, 'MM/DD/YY') DATE FROM 'TABLE'; AMAR

---

AMARENDRA B NETTEM ( http://www.iit.edu/~nettama)   Certified Oracle DBA
  WHITTMAN-HART Inc.
  CHICAGO. Received on Fri Aug 08 1997 - 00:00:00 CDT