我曾尝试在sqlserver2005中存储日期，但出现以下错误 [英] How to store date in sqlserver2005 i have tried but i got following error

问题描述

Protected Sub Button4_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button4.Click

    Dim medate As String = TextBox1.Text
    Dim st As String = ConfigurationManager.ConnectionStrings("testingConnectionString").ToString
    Dim con As New Data.SqlClient.SqlConnection(st)
    con.Open()
    Dim q As String = "insert into mytest values('" & medate & "')"
    Dim com As New Data.SqlClient.SqlCommand(q, con)
    com.ExecuteNonQuery()
    con.Close()
End Sub

我收到以下错误:-

I got the following error :-

Conversion failed when converting datetime from character string.

谁能说出在SQL Server 2005中存储的默认日期格式是什么...
每当我的日价值增加12时，我就会收到错误消息，我会卡在非常重要的部分中，请提供帮助...谢谢

Can any one tell what is the default date format for storage in sql server 2005 ...
When ever my day value increases 12 i get error i m stuck up in very important part please help ... Thanks

推荐答案

您可以执行以下操作

You can do the following

Dim medate As New DateTime
TextBox1.Text = System.DateTime.Today.Date
       medate = DateTime.Parse(TextBox1.Text)
'or medate can have your date of format mm/dd/yyyy
    Dim q As String = "insert into mytest values('" & medate & "')"

可以告诉任何默认日期格式在SQL SERVER 2005中进行存储
SQL Server日期时间格式 [

CAN ANY1 TELL WHAT IS THE DEFAULT DATE FORMAT FOR STORAGE IN SQL SERVER 2005
SQL Server Date Time Format[^]

Always use DateTime datatype for date values and use parameterized query.

尝试一下，

将日期作为Date = Date.Parse(TextBox1.Text.ToString())

try this,

Dim medate As Date = Date.Parse(TextBox1.Text.ToString())

这篇关于我曾尝试在sqlserver2005中存储日期，但出现以下错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！