当前位置:数据库 > Oracle >>

oracle时间大小比较

oracle时间大小比较
 
createtime >to_date( '2006-04-08 00:00:01','yyyy-mm-dd hh24:mi:ss') 

and createtime<to_date('2006-04-08 10:00:01','yyyy-mm-dd hh24:mi:ss')

或者

createtime >to_date( '20060408000001','yyyymmddhh24miss') and createtime<to_date('20060408100001','yyyymmddhh24miss')

javascript时间比较大小

Date.parse("2011-4-9 9:30:00".replace("-","/"))>Date.parse("2011-4-13 15:54:52".replace("-","/"))

 


CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,