beginTime 和 endTime是这样的字符串 2006-09-22 14:59:19timestamp是SQL server2000数据库里面的字段。格式也是 2006-09-22 14:59:19
为什么下面这个SQL查不到东西??
是不是Convert(varchar(19),event.[timestamp],121)不对??SELECT * FROM event WHERE Convert(varchar(19),event.[timestamp],121) BETWEEN @beginTime AND @endTime"
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:snortConnectionString %>"
SelectCommand="SELECT * FROM event WHERE Convert(varchar(19),event.[timestamp],121) BETWEEN @beginTime AND @endTime"
OnSelecting="SqlDataSource1_Selecting">
<SelectParameters>
<asp:Parameter Name="beginTime" Type="dateTime" />
<asp:Parameter Name="endTime" Type="dateTime" />
</SelectParameters>
2 没有时间的DATETIME默认开始时间为00:00:00
3 时间包括BETWEEN条件