declare @tb table (sj datetime) insert into @tb select '2007-03-02'select * from @tb where sj between '2009-10-02' and '2009-10-02 23:59:00'
select * from tb where convert(varchar,sj,120)='2009-10-24'
SqlConnection myConn = new SqlConnection(strConnection); SqlDataAdapter sqlda = new SqlDataAdapter("select * from TableName where 启动时间> '2009-10-25 01:12:12' ", myConn); DataTable dt = new DataTable(); sqlda.Fill(dt); dataGridView1.DataSource = dt;
string strSql=" select * from table where time between to_date('2009-10-02 0:00:00','yyyy-mm-dd hh:mi:ss') and to_date('2009-10-02 23:59:59', 'yyyy-mm-dd hh:mi:ss') "; 其中的时间为你想要的时间范围起始点,在时间后面需要给其定义格式
insert into @tb select '2007-03-02'select * from @tb where sj between '2009-10-02' and '2009-10-02 23:59:00'
SqlConnection myConn = new SqlConnection(strConnection);
SqlDataAdapter sqlda = new SqlDataAdapter("select * from TableName where 启动时间> '2009-10-25 01:12:12' ", myConn);
DataTable dt = new DataTable();
sqlda.Fill(dt);
dataGridView1.DataSource = dt;
其中的时间为你想要的时间范围起始点,在时间后面需要给其定义格式