Android Question Help me about DatePicker

Erel said:

I guess that you are using DBUtils.ExecuteTableView. This method just takes the values as strings and adds them to the TableView.

Which Jdbc driver are you using? Why are you using an access database instead of a proper database?

Click to expand...

Erel said:

You will need to get the string from the database and parse it.

B4X:

Dim dt As String = rs.GetString(...)
dt = dt.Substring2(0, dt.IndexOf(" "))

Click to expand...

Public Sub DateSQL(txtDate As String, tgian As String)
    Dim CurrentFormat As String=DateTime.DateFormat
    DateTime.DateFormat="yyyy-MM-dd HH:mm:ss"
    Dim mysqlDate As String=DateTime.Date(tgian)
    DateTime.DateFormat=CurrentFormat
    txtDate=mysqlDate
End Sub

Dim t As String
    DBUtils.DateSQL(t,Value)
    Log(t)

DonManfred said:

B4X:

Public Sub DateSQL(tgian As String) as String
    Dim CurrentFormat As String=DateTime.DateFormat
    DateTime.DateFormat="yyyy-MM-dd HH:mm:ss"
    Dim mysqlDate As String=DateTime.Date(tgian)
    DateTime.DateFormat=CurrentFormat
    return mysqlDate
End Sub

B4X:

Dim t As String = DBUtils.DateSQL(Value)
    Log(t)

I strongly suggest to learn the B4X Syntax and how the codeflow is!

Click to expand...