假设表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#
に枯叶蝶的未来
2025-06-21 12:28:56
select * from Table where to_date>=('2009-01-01' ,'yyyy-mm-dd') and to_date<=('2009-12-31' ,'yyyy-mm-dd')
