replace # with 'select * from regdata where userid='"&userid&"' and regtime Between '10/01/2003' and '11/01/2003' order by regday
可以是 'yyyy/mm/dd' 'mm/dd/yyyy' 'yyyy-mm-dd'
select cast('11/01/2003' as datetime)select cast('2003-11-01' as datetime)select cast('2003/11/01' as datetime)select cast('20031101' as datetime)....都是可以的。
'mm/dd/yyyy'
'yyyy-mm-dd'
但是在sqlserver里面是用'号就可以了。