ÓÃ.netÔÚmysqlÀï²åÈëʱ¼äÔõôд£¿

oracleÀïÓÐto_date('2009-10-11','yyyy-MM-dd');
mysqlÀïÔõôд£¿

---

¶ÔMYSQL£¬Î¢ÈíûÓÐÖ±½ÓÖ§³Ö£¬ËùÒÔÎÒÓÃodbcÀ´²Ù×÷
ÎÒÓõÄÊÇmysql5µÄ,´úÂëÈçÏ£º
Imports System.Data
Imports System.Data.Odbc

Partial Class _Default
    Inherits System.Web.UI.Page
    Dim mycon As New OdbcConnection("DRIVER={MySQL ODBC 5.1 Driver};SERVER=localhost;DATABASE=mysql;UID=root;PWD=jacklin;")

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim mycmd As New OdbcCommand("select * from users", mycon)
        mycon.Open()
        gv1.DataSource = mycmd.ExecuteReader
        gv1.DataBind()
        mycon.Close()
    End Sub

    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim upcmd As New OdbcCommand("insert into users (username,addtime) values (@a,@b)", mycon)
        mycon.Open()
      Dim upcmd As New OdbcCommand("insert into users ('"+txtname.Text+"','"+txttime.text+"')",mycon)
        upcmd.ExecuteNonQuery()
&n