orcale 把日期当做查询条件

fteair

根据日期查询范围

精确到天

select * from table where to_char( time,'yyyy mm dd ' )  <=   '2000 01 01'

select * from table where to_char( time,'yyyy-mm-dd ' )  <= '2000-01-01'

select * from table where to_char( time,'yyyy/mm/dd ' )  <= '2000/01/01'

精确到秒

select * from table where to_char( time,'yyyy mm dd hh24 mi ss' )  <=   '2000 01 01 12 12 12'

select * from table where to_char( time,'yyyy-mm-dd hh24-mi-ss' )  <= '2000-01-01 12-12-12'

select * from table where to_char( time,'yyyy/mm/dd hh24:mi:ss' )  <= '2000/01/01 12:12:12'

caixuqad

fteair

caixuqad 发表于 2017-10-11 15:20

caixuqad

fteair

张兴康 发表于 2017-10-10 19:09

张兴康

fteair 发表于 2017-10-10 14:30

caixuqad

fteair

张兴康 发表于 2017-10-9 19:21

张兴康

fteair

caixuqad 发表于 2017-10-9 11:44