Query data. Use time as a filter condition. The condition is incorrect.

aoturen · Post time: 2020-3-15 18:00:01

select * from t_inout_all where
to_char (createtime, 'yyyy-mm-dd hh: mm: ss') = '2016-11-28 17:50:00'

createtime is a DATE type

bastard11 · Post time: 2020-6-14 22:15:01

select* from t_inout_all where
to_char(createtime,'yyyy-mm-dd hh24:mm:ss') ='2016-11-28 17:50:00'

idpublic · Post time: 2020-6-16 22:15:01

select * from t_inout_all where
to_char(createtime,'yyyy-mm-dd hh24:mi:ss') ='2016-11-28 17:50:00'

idpublic · Post time: 2020-6-17 18:45:02

mm month
mi points

whbilly · Post time: 2020-6-17 20:00:01

select * from t_inout_all where to_char(createtime,'yyyy-mm-dd hh24:mi:ss') ='2016-11-28 17:50:00'

hh is divided into hh24 and hh12

		Remember me	Forgot password?
Password			Register