SELECT * FROM 表2 WHERE 日期字段='2005-3-7' 如果是 ACCESS,用 SELECT * FROM 表2 WHERE 日期字段=#2005-3-7#
select * from checks where check_time between '2005-3-6'and '2005-3-8';
select * from checks where Convert(NVARCHAR(10),check_time) = '2005-3-7' 数据库会自动将你的时间类型转换成 yyyy-MM-dd 格式的比较。
dim strSQL="select * from checks where check_time between @BEGTIME and @ENDTIME" Button1.Text = Now.Date Button2.Text = Now.Date Dim dat As New SqlDataAdapter(strSQL,m_strConn) Dim dst As New DataSet Dim Para1 As New SqlParameter("@BEGTIME", SqlDbType.DateTime) Dim para2 As New SqlParameter("@ENDTIME", SqlDbType.DateTime) Para1.Direction = ParameterDirection.Input para2.Direction = ParameterDirection.Input dat.SelectCommand.Parameters.Add(Para1) dat.SelectCommand.Parameters.Add(para2) Para1.Value = Now'時間 para2.Value = Now'時間,要是你開始用的是哈char型的話那要把轉換下類型 dat.Fill(dst, "Read") DataGrid1.DataSource = dst.Tables("Read").DefaultView DataGrid1.DataBind()
string SQL1="Select * from works where workid='"+Request.Params["id"]+"'"; SqlCommand Cmd=new SqlCommand(SQL1,Conn); Conn.Open(); SqlDataReader reader = Cmd.ExecuteReader(); reader.Read(); DateTime shijian=reader.GetDateTime(3); string shijian1=Convert(NVARCHAR(10),shijian);
String SQL="Select * from works where Convert(NVARCHAR(10),utime)='"+shijian1+"'"; reader.Close(); DataSet ds=new DataSet(); SqlDataAdapter Adapter=new SqlDataAdapter(SQL,Conn); Adapter.Fill(ds,"works"); DataGrid1.DataSource=ds.Tables["works"].DefaultView; DataGrid1.DataBind(); 我代码是上面的 大家看问题在哪里?
sql 语句里用datediff('day',日期,now)>0,如果大于0就不是同一天的
>='2005-03-07 00:00:00' and <='2005-03-07 23:59:59' or convert(varchar(10),shijian,101)
select * from table2 where datediff(day,[table2datefield],'2005-3-7')=0
string sql = "select * from table2 where datediff(day,[table2datefield],'" + yourDate.ToString() + "')=0";如何?
SELECT * FROM 表2 WHERE 日期字段=#2005-3-7#
数据库会自动将你的时间类型转换成 yyyy-MM-dd 格式的比较。
dim strSQL="select * from checks where check_time between @BEGTIME and @ENDTIME"
Button1.Text = Now.Date
Button2.Text = Now.Date
Dim dat As New SqlDataAdapter(strSQL,m_strConn)
Dim dst As New DataSet
Dim Para1 As New SqlParameter("@BEGTIME", SqlDbType.DateTime)
Dim para2 As New SqlParameter("@ENDTIME", SqlDbType.DateTime)
Para1.Direction = ParameterDirection.Input
para2.Direction = ParameterDirection.Input
dat.SelectCommand.Parameters.Add(Para1)
dat.SelectCommand.Parameters.Add(para2)
Para1.Value = Now'時間
para2.Value = Now'時間,要是你開始用的是哈char型的話那要把轉換下類型
dat.Fill(dst, "Read")
DataGrid1.DataSource = dst.Tables("Read").DefaultView
DataGrid1.DataBind()
SqlCommand Cmd=new SqlCommand(SQL1,Conn);
Conn.Open();
SqlDataReader reader = Cmd.ExecuteReader();
reader.Read();
DateTime shijian=reader.GetDateTime(3);
string shijian1=Convert(NVARCHAR(10),shijian);
String SQL="Select * from works where Convert(NVARCHAR(10),utime)='"+shijian1+"'";
reader.Close();
DataSet ds=new DataSet();
SqlDataAdapter Adapter=new SqlDataAdapter(SQL,Conn);
Adapter.Fill(ds,"works");
DataGrid1.DataSource=ds.Tables["works"].DefaultView;
DataGrid1.DataBind();
我代码是上面的
大家看问题在哪里?
or
convert(varchar(10),shijian,101)