postgresql数据库拆分时间与日期
select id,
exam_date::date as t_date,
exam_date::time as t_time
FROM public.t_exam_demo
order by exam_date desc
limit 100
postgresql数据库拆分时间与日期
select id,
exam_date::date as t_date,
exam_date::time as t_time
FROM public.t_exam_demo
order by exam_date desc
limit 100