Case statement for a date field with Mysql db

Question

Iam trying to do a CASE statement. The requirement is if Date field is NULL then show it as 'Pending' or else show the date from the db.

I have tried the below case statement but there is some problem.

CASE po_amend_received_date IS NULL WHEN 1 THEN 'Pending'  
ELSE po_amend_received_date END AS `po_amend_received_date`

Am i making any mistake here?

Read this: http://stackoverflow.com/questions/15265874/case-statement-in-mysql — Muhammad Muazzam, Mar 14 '16 at 07:30

score 0 · Accepted Answer · answered Mar 14 '16 at 07:29

0

CASE WHEN po_amend_received_date IS NULL THEN 'Pending'  
else  po_amend_received_date 
end as `po_amend_received_date`

answered Mar 14 '16 at 07:29

Ankit Agrawal

1 Answers1