求一条时间类型的数据库查询语句

Question

对于 t-sql 语言来说，时间类型常量是以字符串方式来表示的。例如string sql = string.Format("select abc from table where rpt_time between '{0}] and {1}", dt1.ToString("yyyy-M-d h:m:s"),dt2.ToString("yyyy-M-d h:m:s"));

Answer 1

]  符号打错了，应该是    "select abc from table where rpt_time between '{0}‘ and ‘{1}’"

Answer 2

Tsql可以直接用时间字符串；
plsql需要用to_date转换在查询。

Answer 3

查询数据库日期间隔时段的数据信息示例
//查询性别年龄
  <asp:RadioButtonList ID="radlistSex" runat="server" RepeatDirection="Horizontal"
                Width="80px" Font-Size="12px">
                <asp:ListItem Selected="True"> 男</asp:ListItem>
                <asp:ListItem>女</asp:ListItem>
            </asp:RadioButtonList>
<asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/image/f2.jpg" 
                onclick="ImageButton1_Click1" />//查询按钮
//点击查询事件
 protected void ImageButton1_Click1(object sender, ImageClickEventArgs e)
    {           Session["searchKey2"] = radlistSex.SelectedValue.Trim();
           Response.Redirect("Ssdiqu_nn.aspx");
     }//codego.net/tags/11/1/
//跳转查询页面显示查询数据
<asp:DataList ID="DataList1" runat="server" RepeatColumns="2" Width="600px" Height="403px">
                    <ItemTemplate>
                        <table style="font-size: 10pt; height: 100px" border="0" cellpadding="0" cellspacing="0">
                            <tr>
                                <tr>
                                    <td rowspan="6" style="width: 120px; height: 100px;">
                                        <img alt="查看图片" id="image" src='<%#Eval("Images")%>' style="border: 0" width="100" />
                                    </td>
                                    <td style="width: 220px; height: 20px; text-align: left; font-size: 9pt; vertical-align: middle;">
                                        客户名称：<%# Eval("UserName") %>
                                    </td>
                                </tr>
                                <tr>
                                    <td style="width: 220px; height: 20px; text-align: left; vertical-align: middle">
                                        地址：<%# Eval("Province") %>省<%# Eval("city") %>市
                                    </td>
                                </tr>
                                <tr>
                                    <td style="width: 220px; height: 20px; text-align: left; vertical-align: middle">
                                        QQ号码：<%# Eval("QQ") %>
                                    </td>
                                </tr>
                                <tr>
                                    <td style="width: 220px;">
                                        昵称：<%# Eval("sex") %>
                                    </td>
                                </tr>
                                <tr>
                                    <td style="width: 220px;">
                                        详细信息：<a href='xiang_xi.aspx?HenuID=<%#Eval("HenuID") %>'><%# Eval("UserName") %></a>
                                    </td>
                                </tr>
                            </tr>
                        </table>
                    </ItemTemplate>
                </asp:DataList>
//处理查询页面SQL语句
 protected void bindDataList()
    {        int noncePage = Convert.ToInt32(labPage.Text);
        PagedDataSource ps = new PagedDataSource();
        string sqlSel1 = "select * from tb_huen_lian,tb_HuenLian where ICQ between '1984-01-01' and '1995-01-01' and tb_huen_lian.UserName = tb_HuenLian.UserName and tb_HuenLian.sex like '%" + Session["searchKey2"] + "%'";//查询30岁到21岁男或女两个数据表名称相同的数据
        ps.DataSource = operateData.getRows(sqlSel1).DefaultView;
        ps.AllowPaging = true;
        ps.PageSize = 8;
        ps.CurrentPageIndex = noncePage - 1;
        this.lnkbtnFront.Enabled = true;
        this.lnkbtnNext.Enabled = true;
        this.lnkbtnLast.Enabled = true;
        this.lnkbtnFirst.Enabled = true;
        if (noncePage == 1)
        {
            this.lnkbtnFirst.Enabled = false;//不显示第一页按钮
            this.lnkbtnFront.Enabled = false;//不显示上一页按钮
        } if (noncePage == ps.PageCount)
        {
            this.lnkbtnNext.Enabled = false;//不显示下一页
            this.lnkbtnLast.Enabled = false;//不显示最后一页
        }
        labBackPage.Text = Convert.ToString(ps.PageCount);
        DataList1.DataSource = ps;
        DataList1.DataBind();    }//分页（略）