1.日期(datetime类型)转时间戳
EXTRACT ( epoch FROM NOW())
EXTRACT ( epoch FROM CAST ( time AS TIMESTAMP ) )
注意:time是表中的一个字段,它的格式为yyyy-MM-dd HH:MM:SS
实际应用:
SELECT
'xcq' AS title,
COUNT ( jq.* ) AS caseinfo
FROM
nmg_fz_warning_record record,
fz_jq_case_info jq
WHERE
record.warning_time > EXTRACT ( epoch FROM CAST ( jq.报警时间 AS TIMESTAMP ) )
AND jq.联系电话 = record.mobile
2.时间戳转日期
to_char(to_timestamp(start_time),'yyyy-MM-dd')
select to_char(to_timestamp(start_time),'yyyy-MM-dd') from testTab