Posted by <talthen.z-serwera.o2 on 09/29/42 11:46

Hello,
When I fill datetime field with empty string I get "0000-00-00 00:00:00"-
it's fine, but when I display it I want the string 'NO' instead of these
zeros.
So... how can I specify 'NO' as default value for datetime value?
OR
How can I show dates and replace all dates="0000-00-00 00:00:00" with 'NO'?

All I have made is-
SELECT 'NO' FROM `tab` WHERE SUBSTRING(date,0,1)='0'
But I dunno how do add showing non-zero dates... in one query.

Regards,
Talthen

• Next in forum: Re: How can I specify 'NO' as default value for datetime value or convert default value into 'NO' in query?
• Prev in forum: Re: little problem
• Thread view: How can I specify 'NO' as default value for datetime value or convert default value into 'NO' in query?

[Reply to this message]