假设表table1中有字段setdate(date类型)
oracle语法:select
*
from
table1
where (to_char(setdate,'yyyy-mm-dd')
between
'2009-01-01'
and
'2009-12-31')
sqlserver语法:select
*
from
table1
where setdate
between
'2009-01-01'
and
'2009-12-31'
access语法:select
*
from
table1
where setdate
between
#2009-01-01#
and
#2009-12-31#
温馨提示:答案为网友推荐,仅供参考