To answer my own question, this worked:

SELECT name,

address,

email,

CASE

WHEN date = '0001-01-01'

OR date is null

THEN ''

ELSE varchar(date,iso)

END as date

FROM mytable

WHERE name = 'john'