1.带时间的日期与不带时间日期比较 ,要先转换成只有日期的字符串再比较;例如:
to_date(to_char('2008/04/29 10:00:59','yyyy/mm/dd')) between to_date('2008/04/29','yyyy/mm/dd') and to_date('2008/05/30','yyyy/mm/dd')
2.当字段名与关键字重名时 ,用双引号,且必是大写即可。如select col1,col2, "ID " from ...
1.带时间的日期与不带时间日期比较 ,要先转换成只有日期的字符串再比较;例如:
to_date(to_char('2008/04/29 10:00:59','yyyy/mm/dd')) between to_date('2008/04/29','yyyy/mm/dd') and to_date('2008/05/30','yyyy/mm/dd')
2.当字段名与关键字重名时 ,用双引号,且必是大写即可。如select col1,col2, "ID " from ...