1 判断时间是否具体到时分秒
SELECT CASE WHEN TO_CHAR (DJSJ,' hh24:mi:ss') LIKE '%00:00:00' THEN 'DJSJ未精确到时分秒'
ELSE 'DJSJ精确到时分秒' END AS DJSJ_VALID_FALG
FROM
(
SELECT DJSJ , to_char (DJSJ,' hh24:mi:ss') AS DETAIL_SJ
FROM TABLE_NAME
)