where date between to_date('20070501','yyyymmdd') and to_date('20070502','yyyymmdd') 或者 select to_char(date,'yyyy-mm-dd'),.. where to_char(date,'yyyy-mm-dd')='2007-05-01'
完整的应该 select .. from .. group by 列名 having to_date(to_char('列名'),'yyyy-mm-dd')
select to_char(字段,'yyyy/MM/dd') AS A from 表 group by to_char(字段,'yyyy/MM/dd') order by A
select to_char(字段,'yyyy/MM/dd') AS A from 表 // where // to_char(字段,'yyyy/MM/dd') = '2007/05/01' group by to_char(字段,'yyyy/MM/dd') order by A这才是正确的.
或者
select to_char(date,'yyyy-mm-dd'),..
where to_char(date,'yyyy-mm-dd')='2007-05-01'
select .. from ..
group by 列名 having to_date(to_char('列名'),'yyyy-mm-dd')
from 表
group by to_char(字段,'yyyy/MM/dd')
order by A
from 表
// where
// to_char(字段,'yyyy/MM/dd') = '2007/05/01'
group by to_char(字段,'yyyy/MM/dd')
order by A这才是正确的.