数据:--表名为SalesTable
/*
Amount SalesDate
1 2010-03-09 13:45:27.000
1 2010-03-09 11:00:27.000
2 2010-03-07 10:05:00.000
3 2010-03-05 10:11:03.000
6 2010-03-08 09:00:00.000
*/
目的:查出SalesDate字段在2010-03-07 致2010-03-09 的记录,要求结果以下:
/*
Amount SalesDate
2 2010-03-07 10:05:00.000
6 2010-03-08 09:00:00.000
1 2010-03-09 13:45:27.000
1 2010-03-09 11:00:27.000
*/
/*
Amount SalesDate
1 2010-03-09 13:45:27.000
1 2010-03-09 11:00:27.000
2 2010-03-07 10:05:00.000
3 2010-03-05 10:11:03.000
6 2010-03-08 09:00:00.000
*/
目的:查出SalesDate字段在2010-03-07 致2010-03-09 的记录,要求结果以下:
/*
Amount SalesDate
2 2010-03-07 10:05:00.000
6 2010-03-08 09:00:00.000
1 2010-03-09 13:45:27.000
1 2010-03-09 11:00:27.000
*/
*
FROM
TB
WHERE CONVERT(CHAR(10),SalesDate,120) BETWEEN '2010-03-07' AND '2010-03-09'
*
FROM
TB
WHERE SalesDate>='2010-03-07' AND SalesDate<'2010-03-10'