sql server选择查询两个日期 [英] Sql server select query betwwen two dates

问题描述

我有一张桌子1



其中有一个列名'date'，数据类型是datetime



nd现在我想在两个日期之间选择，这是datetimepicker的值

我是怎么做的。

解决方案

  SELECT  datefield 
  FROM  表 
  WHERE  datefield  BETWEEN   @ date1   AND   @ date2  

RyanDev的Solution1非常好，我会添加一些额外的信息。



你可以使用带有body的存储过程，如上所示。请阅读：如何：执行返回行的存储过程 [ ^ ]

i have a table1

in which there is a column name 'date' which datatype is datetime

nd now i want select between two dates which is the value from datetimepicker
how i do it.

解决方案

SELECT datefield
FROM table
WHERE datefield BETWEEN @date1 AND @date2

Solution1 by RyanDev is very good and i would add some extra information.

You can use stored procedure with body as is shown above. Please, read this: How to: Execute a Stored Procedure that Returns Rows[^]

这篇关于sql server选择查询两个日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！