SELECT * FROM insdec WHERE cast(timein as date) between 'vart1' and 'vart2'
SELECT * FROM insdec WHERE convert(datetime,timein) between 'vart1' and 'vart2'不过使用between的时候,当vart1没有输入的时候,也就是为'',这时候timein字段所有为空的全部显示出来了,如果不想有这样的问题,就要使用 SELECT * FROM insdec where convert(datetime,timein)<'vart2' and convert(datetime,timein)>'vart1'
SELECT * FROM insdec WHERE timein between #varta# and #vartb#搞定了,我用的是asp+sql+vbscript,所以你们说得他不认convert这个函数还是谢了
FROM insdec
WHERE cast(timein as date) between 'vart1' and 'vart2'
FROM insdec
WHERE convert(datetime,timein) between 'vart1' and 'vart2'不过使用between的时候,当vart1没有输入的时候,也就是为'',这时候timein字段所有为空的全部显示出来了,如果不想有这样的问题,就要使用
SELECT *
FROM insdec
where convert(datetime,timein)<'vart2' and convert(datetime,timein)>'vart1'
FROM insdec
WHERE timein between #varta# and #vartb#搞定了,我用的是asp+sql+vbscript,所以你们说得他不认convert这个函数还是谢了