原始格式:
select Starttime,Endtime from ELEARNING.Opt_Training where Orgid = '6c457da0-7825-4df7-bcd7-0e0e9c37631b';
查询结果:
查询格式:to_char()函数,返回yyyy/MM/dd:
select to_char(Starttime,'yyyy/MM/dd'),to_char(Endtime,'yyyy/MM/dd') from ELEARNING.Opt_Training where Orgid = '6c457da0-7825-4df7-bcd7-0e0e9c37631b';
查询结果:
模糊查询:
select * from CAINIAO_MONITOR_MSG t WHERE to_char(t.CREATE_TIME,'yyyy-MM-dd') like '2019-09-12';