如何转换datetime值的日期:我有在database.i datetime值需要通过querystring的日期,所以我想通过转换功能转换成日期的datetime
这里是我的代码
它会返回一个错误:一个char数据类型到datetime数据类型的转换导致datetime值范围的SqlCommand comm1 = new SqlCommand("select distinct trackorder,netprice,recip_name,bill_name,convert(varchar,date,103) from tbl_trackorder join tbl_users_products on tbl_trackorder.usersess=tbl_users_products.usersession join tbl_recipient on tbl_users_products.usersession=tbl_recipient.usersession join tbl_billing on tbl_recipient.usersession=tbl_billing.usersession join tbl_session_user on tbl_session_user.usersession=tbl_recipient.usersession and tbl_session_user.usersession=tbl_billing.usersession where tbl_session_user.date='"+date+"'", sqlcon);
SqlDataAdapter dap = new SqlDataAdapter();
dap.SelectCommand = comm1;
DataSet dss = new DataSet();
dap.Fill(dss);
return dss;
任何一个可以帮助我。
谢谢| Thendral.N:赖斯