一些常用sql的写法记录

整型

select * from PM_ZDT_DCJXSB where inst_id = 635982;

select * from PM_ZDT_DCJXSB where inst_id between 635982  and 635987;

字符型

select * from PM_ZDT_DCJXSB where PM_ZDT_DCJXSB.SBMC='绞龙'；

日期型

select * from PM_ZDT_DCJXSB where to_char(jxjssj,'yyyy-mm-dd')='2006-12-07';
 
select * from PM_ZDT_DCJXSB where to_char(jxjssj,'yyyy-mm-dd')>'2006-12-07';

select * from PM_ZDT_DCJXSB where to_char(jxjssj,'yyyy-mm-dd')>='2006-12-07';

select * from PM_ZDT_DCJXSB where to_char(jxjssj,'yyyy-mm-dd')>='2006-12-07' and to_char(jxjssj,'yyyy-mm-dd')<='2006-12-12';

select   *   from   date_table   where   to_char(datetime,'yyyy-mm-dd')='2005-06-14'