如何在sql server中使用between之间找到两个不同的日期值 [英] how to find two different date values using between in sql server

问题描述

有人帮我在sql server中获取两个不同的日期行值。



如果我已经添加了这样的话



select * from Tablename其中Columnname在'6/24/2013 12:00:00 AM'和'6/27/2013 12:00:00 AM'



但是这个查询只检查月份和日期，所以我有很多行。这也是明年的价值观。所以请帮助我知道这个问题的答案。



6/3/2013 12:00:00 AM 200 300 400 120

6/24/2013 12:00:00 AM 200 350 600 150

6/25/2013 12:00:00 AM 200 350 600 150

6/26 / 2013 12:00:00 AM 200 350 600 150

6/27/2013 12:00:00 AM 200 350 600 150

6/3/2014 12： 00:00 AM 200 300 400 120

6/24/2014 12:00:00 AM 200 350 600 150

6/25/2014 12:00:00 AM 200 350 600 150

6/26/2014 12:00:00 AM 200 350 600 150

6/27/2014 12:00:00 AM 200 350 600 150

Anybody help me to get two different date rows values in sql server.

if i already added like this

" select * from Tablename where Columnname between '6/24/2013 12:00:00 AM' and '6/27/2013 12:00:00 AM' "

but this query will check only month and date so i got lot of rows. this is taken next year values also. so please help me anybody know the answer for this problem.

6/3/2013 12:00:00 AM 200 300 400 120
6/24/2013 12:00:00 AM 200 350 600 150
6/25/2013 12:00:00 AM 200 350 600 150
6/26/2013 12:00:00 AM 200 350 600 150
6/27/2013 12:00:00 AM 200 350 600 150
6/3/2014 12:00:00 AM 200 300 400 120
6/24/2014 12:00:00 AM 200 350 600 150
6/25/2014 12:00:00 AM 200 350 600 150
6/26/2014 12:00:00 AM 200 350 600 150
6/27/2014 12:00:00 AM 200 350 600 150

推荐答案

如果你的< Columnname> 日期时间类型然后您可以通过以下方式轻松完成：



从表名中选择*其中（[Columnname] BETWEEN '06 -24 -2013'AND '06 -27-2013'）



我希望这会对你有所帮助。

If your <Columnname> is datetime type then you could easily done it by likes below:

select * from Tablename where ([Columnname] BETWEEN '06-24-2013' AND '06-27-2013')

I hope this will help to you.

首先你需要检查日期格式的类型？



http://www.sql-server-helper.com/tips/date-formats.aspx [ ^ ]



检查该链接并查看日期格式类型。



然后使用select语句你可以得到数据。



从[tbl_name]中选择*其中< ; COL_NAME>在'YYYY-MM-DD HH：MM：SS'和'YYYY-MM-DD HH：MM：SS'之间

first you need to check in what type the date format is?

http://www.sql-server-helper.com/tips/date-formats.aspx[^]

Check that link and see the date format types.

then using select statement you can get data.

Select * from [tbl_name] where <col_name> between 'YYYY-MM-DD HH:MM:SS' and 'YYYY-MM-DD HH:MM:SS'

这篇关于如何在sql server中使用between之间找到两个不同的日期值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！