有关SQL中的Begin子句的日期时间的问题 [英] Problem regarding Between clause For date time in SQL

问题描述

sql查询，用于过滤到存储在sql数据库中的日期之间的数据，而忽略时间部分.

例如.
我必须在2011-08-05 05:22:44:00至2011-08-25 05:33:12:18之间过滤数据 忽略时间部分

Sql query to filter data between to dates stored in sql database ignoring the time part.

For eg.
I have to filter data between 2011-08-05 05:22:44:00 to 2011-08-25 05:33:12:18
ignoring the time part

推荐答案

尝试:

SELECT * FROM myTable WHERE myDate BETWEEN '2011-08-05' AND '2011-08-25'

请注意，BETWEEN包含在内，因此两个日期都将出现在结果中.

Note that BETWEEN is inclusive, so both dates will be in the results.

SQL Server日期格式 [ ^ ]
像下面这样采样一个

SQL Server Date Formats[^]
Sample one like below

SELECT * FROM TableName WHERE DateColum BETWEEN CONVERT(VARCHAR(10), GETDATE(), 101) AND CONVERT(VARCHAR(10), GETDATE(), 101)

请考虑以下示例:

Consider the following example:

Create Table Events(ID int, EDate datetime)
insert into events values (1, '2011-08-05 05:22:44:00')
insert into events values (2, '2011-08-05 07:22:44:00')
insert into events values (3, '2011-08-25 05:33:12:18')
insert into events values (4, '2011-08-25 03:33:12:18')

This will give you all records

select * from events where eDate between '2011-08-05 05:22:44:00' and '2011-08-25 05:33:12:18'

1	2011-08-05 05:22:44.000
2	2011-08-05 07:22:44.000
3	2011-08-25 05:33:12.017
4	2011-08-25 03:33:12.017

This will give you selected records (excluding the third record)

select * from events where eDate between '2011-08-05 05:22:44:00' and '2011-08-25 03:33:12:18'
1	2011-08-05 05:22:44.000
2	2011-08-05 07:22:44.000
4	2011-08-25 03:33:12.017

希望对您有所帮助.

Hope this helps..

这篇关于有关SQL中的Begin子句的日期时间的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！