有关时间存入数据库后发生改变的问题 Convert.ToDateTime (txtTime) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 对,我就是用的ToDateTime,可是还是不行.... impossibly,your code has some questions.pls check it or post it. OK..txtPicDatetime.Text = Now.Today............................Dim datetimepic As Datedatetimepic = Convert.ToDateTime(txtPicDatetime.Text.ToString) strSql = "Insert into BluePrintInfo (..,PicDatetime,..) values " & "(" _ & .. & "," & datetimepic & "," & .. & ")"............................能够正常插入,本来是2003-8-18,存入数据库中却变成1905-5-30 strSql = "Insert into BluePrintInfo (..,PicDatetime,..) values " & "(" _ & .. & "," & datetimepic & "," & .. & ")"------------------->strSql = "Insert into BluePrintInfo (..,PicDatetime,..) values " & "(" _ & .. & ",'" & datetimepic & "'," & .. & ")" 数据中心数据上传下载方案讨论 SQL里获取长时间里的年月日 SQL身份验证 求一关联查询的SQL语句 请问如何才能利用索引才执行下面这条简单的查询语句 高分求教,插表出错!急 一个简单得SQL语句 top系统--3 sqlserver2000 新建数据库时出现(ODBC SQLstate:42000) 在线等!事关就业!请教高手,大家都来给点意见 就10分了, 再问大力 大家救救我,帮我看看
pls check it or post it.
............................
Dim datetimepic As Date
datetimepic = Convert.ToDateTime(txtPicDatetime.Text.ToString)
strSql = "Insert into BluePrintInfo (..,PicDatetime,..) values " & "(" _
& .. & "," & datetimepic & "," & .. & ")"
............................
能够正常插入,本来是2003-8-18,存入数据库中却变成1905-5-30
strSql = "Insert into BluePrintInfo (..,PicDatetime,..) values " & "(" _
& .. & "," & datetimepic & "," & .. & ")"
------------------->strSql = "Insert into BluePrintInfo (..,PicDatetime,..) values " & "(" _
& .. & ",'" & datetimepic & "'," & .. & ")"