一些用到的SQL语句

1、时间区间的sql语句：

select * from 表 where to_char(a_date,'yyyymmddhh24miss')>'201505072300' and to_char(a_date,'yyyymmddhh24miss')<'201505080600';

2、varchar 类型 转换成  Int 类型 

select cast(t.termno  as   int) as termno,t.type  from   WANTUP_TMS_SELFTERM t where termno>310015

3、获取系统时间

calldate=sysdate