SELECT * FROM YourTable WHERE YourDate BETWEEN '20030220 00:00:00' AND '20030220 23:59:59'
一楼的语句在access中查询 二楼的语句在sql中查询
Select * form 表名 where [date] between #日期# And #日期# 日期格式为年-月-日
楼主是想问如何知道那个字段是日期型的吧。 Dim fld As ADODB.Field 'Open recordset... For Each fld In rstSRC.Fields Select Case fld.Type Case adVarChar: 'String '.... Case adDate: '.... Case Else: ' '....
二楼的语句在sql中查询
日期格式为年-月-日
Dim fld As ADODB.Field
'Open recordset...
For Each fld In rstSRC.Fields
Select Case fld.Type
Case adVarChar: 'String
'....
Case adDate:
'....
Case Else: '
'....
End Select
Next