如何按日期搜索记录? [英] how to search records by Date?

问题描述

hi如何按日期搜索记录?如何为此创建sp ..
在我的表中tblCurrencySale

hi how to search records by date?how to create sp for this..
in my table tblCurrencySale

csID int(pk)
csPurchaseAmount varchar(50)
csSoldAmount varchar(50)
csProfitAmount varchar(50)
csDate varchar(50)

这是我的表格列，所以我想按日期搜索记录.它应该只显示当天的记录.所以你可以建议我吗?
在此先感谢..

this my table columns so by date i want to search records.and it should display records of that day only..so can u suggest me?
thanks in advance..

推荐答案

朋友，

检查以下代码...

只需在您的过程中包括以下sql语句...
这会很好...

Hi Friend,

Check this below code...

just include the following sql statements in ur Procedure...
this will work fine...

select * from tblCurrencySale  where Convert(varchar(10),csDate,101)  between '05/01/2012' and '05/12/2012'

这篇关于如何按日期搜索记录?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！