ORA-01849: hour must be between 1 and 12

《oracle 就是矫情》

 

ORA-01849: hour must be between 1 and 12

错误：

select * from SCORE_ORDER t where app_create_time between to_date('2016/08/04 00:00:00','yyyy/MM/dd HH:mi:ss') and to_date('2016/08/04 23:00:00','yyyy/MM/dd HH:mi:ss')

更正：

select * from SCORE_ORDER t where app_create_time between to_date('2016/08/04 00:00:00','yyyy/MM/dd HH24:mi:ss') and to_date('2016/08/04 23:00:00','yyyy/MM/dd HH24:mi:ss')

 

=========================

HH --     Hour of day (1-12).
HH12 -- Hour of day (1-12).
HH24 -- Hour of day (0-23).
MI --  Minute (0-59).
SS -- Second (0-59).

==================