Android Question problems with date and time

Bladimir Silva Toro

Active Member
Licensed User
Longtime User
When consulting the date and time of an invoice saved in a MS SQL Server database in B4A, the time is advanced by 5 hours I do not know why this is coming out, I leave the code in B4A:

B4X:
FecFact=records(result.Columns.Get("Fecha"))
DateTime.DateFormat  = "dd/MM/yyyy HH:mm:ss"
Log ("Date Time BD: "&FecFact)
Log(DateTime.Date(FecFact))
Log(DateTime.Time(FecFact))

The following is shown in the log:

upload_2018-12-19_12-4-52.png


In the MS SQL Server database the time is different

upload_2018-12-19_12-7-2.png


Any help is very grateful
 
Top