<select id="test" parameterType="map" resultType="string">
SELECT
( CASE WHEN a.time = 0 THEN '' ELSE to_char( to_timestamp( a.time ), 'yyyy-MM-dd HH24:MI:SS' ) END ) AS time
FROM user a
WHERE
id = #{id}
</select>
<select id="test" parameterType="map" resultType="string">
SELECT
( CASE WHEN a.time = 0 THEN '' ELSE to_char( to_timestamp( a.time ), 'yyyy-MM-dd HH24:MI:SS' ) END ) AS time
FROM user a
WHERE
id = #{id}
</select>