ispring

2008-07-21

CREATE TABLE #Test
(
createDate varchar(8)
)

INSERT INTO #Test
SELECT '20080602'
UNION ALL
SELECT '20080603'
UNION ALL
SELECT '20080701'

SELECT * FROM #Test

-----------------------------------------------
SELECT * FROM #Test
WHERE CAST(createDate as datetime)
BETWEEN '20080604' AND '20080730' [查询方式一]

-----------------------------------------------

SELECT * FROM #Test1
WHERE cast(createDate as datetime)
BETWEEN '2008-06-04' AND '2008-07-30' [查询方式二：与方式一效果一样]

------------------------------------------------

SELECT * FROM #Test1
WHERE cast(createDate as datetime)
BETWEEN '2008/06/04' AND '2008/07/30' [查询方式三：与方式一，二效果同]

-----------------------------------------------