SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Date NVL Not Returning Null Value

785060Mar 19 2012 — edited Mar 19 2012

Hello,

I have to get NVL for date if date is null, but it returns nothing with the following sql.

SELECT   NVL(TO_CHAR(PRODUCT_DATE,'MM/DD/YYYY'),'NA') dt 
from product_master where product_no = 'SG9800'

How can I get NA if PRODUCT_DATE is null?

Thanks

This post has been answered by 647939 on Mar 19 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 16 2012

Added on Mar 19 2012

8 comments

15,318 views