Bladimir Silva Toro Active Member Licensed User Longtime User Dec 19, 2018 #1 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: Code: 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: In the MS SQL Server database the time is different Any help is very grateful
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: Code: 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: In the MS SQL Server database the time is different Any help is very grateful
Bladimir Silva Toro Active Member Licensed User Longtime User Dec 19, 2018 #3 if it works perfect when the smartphone changes its Timezone. Thank you @eps Upvote 0