自己顶下select LanguageCourseDate from tblGetVisaInformation where LanguageCourseDate between 1982-12-12 and 1982-12-12
string querystr = "select count(*) from st_r0 where stcd='" + czdm + "'"; querystr = querystr + " and ymdhm>='" + tim1 + "'" + " and ymdhm<='" + tim2 + "'";
select LanguageCourseDate from tblGetVisaInformation where LanguageCourseDate between '1982-12-12' and '1982-12-12'
select LanguageCourseDate from tblGetVisaInformation where LanguageCourseDate between '1982-12-12' and '1982-12-12'
后台,根据两个文本日期来进行查询. select LanguageCourseDate from tblGetVisaInformation where LanguageCourseDate between '" + txtBegin.Text + "' and '" + txtEnd.Text + "'
select LanguageCourseDate from tblGetVisaInformation where LanguageCourseDate between '1982-12-12' and '1982-12-12 '或者select LanguageCourseDate from tblGetVisaInformation where LanguageCourseDate between CAST('1982-12-12' AS DateTime) and CAST('1982-12-12' AS DateTime)
在sql中,日期类型与字符串之间是可以隐式自动转换的.而别的类型不可以,楼主您的语句可以这样改一下就可以了: select LanguageCourseDate from tblGetVisaInformation where LanguageCourseDate between '1982-12-12' and '1982-12-13' 因为sql中只有日期时间类型,所以在没有给出时间部分的日期时间类型数据中,系统自动添加时间部分,并且是00:00:00 000,也就是午夜0点0分0秒,要想查询1982年12月12日的这一天的数据,那么就需要用1982-12-12 00:00:00 000 到1982-12-13 00:00:00 000这个范围来限定.
select LanguageCourseDate from tblGetVisaInformation where LanguageCourseDate between '1982-12-12' and '1982-12-12'
querystr = querystr + " and ymdhm>='" + tim1 + "'" + " and ymdhm<='" + tim2 + "'";
select LanguageCourseDate from tblGetVisaInformation where LanguageCourseDate between '1982-12-12' and '1982-12-12'
select LanguageCourseDate from tblGetVisaInformation where LanguageCourseDate between '" + txtBegin.Text + "' and '" + txtEnd.Text + "'
select LanguageCourseDate from tblGetVisaInformation where LanguageCourseDate between '1982-12-12' and '1982-12-12 '或者select LanguageCourseDate from tblGetVisaInformation where LanguageCourseDate between CAST('1982-12-12' AS DateTime) and CAST('1982-12-12' AS DateTime)
select LanguageCourseDate from tblGetVisaInformation where LanguageCourseDate between '1982-12-12' and '1982-12-13'
因为sql中只有日期时间类型,所以在没有给出时间部分的日期时间类型数据中,系统自动添加时间部分,并且是00:00:00 000,也就是午夜0点0分0秒,要想查询1982年12月12日的这一天的数据,那么就需要用1982-12-12 00:00:00 000 到1982-12-13 00:00:00 000这个范围来限定.