Android Question When I search for a datetime record from a MySQL table, it returns with one (1) hour less. using JRDC

[julio steinert]

Wait For(jRDC.GetRecord("selectdados", Parametros)) Complete (Answer As Map)
If Answer.Get("Success") Then
Dim l As List
Dim rs As DBResult
rs = Answer.Get("Data")
l = rs.Rows
If l.Size > 0 Then 'We get a result

For Each row() As Object In l
Dim HORA, MINUTO As Int
HORA = DateTime.GetHour(row(10))
MINUTO = DateTime.GetMinute(row(10))

 

[MicroDrie]

I suspect it has to do with the time in the different time zones and how your MySQL server and your B4A device handle this. This problem is discussed in detail at How to store a datetime in MySQL with timezone info.

 

[julio steinert]

I suspect it has to do with the time in the different time zones and how your MySQL server and your B4A device handle this. This problem is discussed in detail at How to store a datetime in MySQL with timezone info.

The data is stored correctly, but when required, it returns with 1 hour less. I don't know if it's something related to Java.

 

[MicroDrie]

You can check the current time zones in MySQL as follows:

SELECT @@global.time_zone, @@session.time_zone;