Date时间类型的查询结果值总是“0000：00：00”，请问有没有办法让查询值显示为空

[9koran]

As title!

[julychina]

if ($date_fild="0000-00-00")(echo " ";}

[loveflea]

select replace("0000:00:00","0000:00:00","") as datetime;

look like this

select replace(your_date_col,"0000:00:00","") as datetime from your_table;