Get Mysql Timestamp to textbox with your own format

[acidsnake]

here is my complete code for it

Dim conn As New MySqlConnection(connStr)
            conn.Open()

            Dim reader As MySqlDataReader

            Dim cmd_date As New MySqlCommand("SELECT timestamp FROM allmessage WHERE status='sent' ORDER BY ID DESC LIMIT 0, 1", conn)

            reader = cmd_date.ExecuteReader


            While reader.Read


                Dim i As Date = reader.GetDateTime("timestamp")
                TextBox2.Text = Format(CDate(i), "yyyy-dd-MM HH:mm:ss")

            End While

            conn.Close()

declare this function

Public Function GetDateTime(ByVal ordinal As Integer) As DateTime

End Function