Android Question Date/time diff?

Facilauto Juan · Nov 26, 2013

Hello there!

I have a date/time in my mysql server and a date/time in my phone. I want to know what is the difference between those dates in order to add or substract that amount of time from every insert I made in my mysql server.

Is this possible?

Thanks in advance.

Erel · Nov 27, 2013

It is possible. However you need to provide more information.

Facilauto Juan · Nov 27, 2013

I get the date_time from my sql server in string with this format "2013-11-26 00:00:00".
I get the actual date_time from my phone in ticks with DateTime.Now
I need to find the difference between the two (in seconds, in ticks, I don't mind).
I'll add or substract that difference at every datetime y have in my local database records in the very moment I insert it in my remote mysql server.

Thanks for the responses in advance!

Erel · Nov 27, 2013

This should help you get started:

B4X:

Sub Activity_Create(FirstTime As Boolean)
   Dim s As String = "2013-11-26 00:00:00"
   DateTime.DateFormat = "yyyy-MM-dd hh:mm:ss"
   Dim serverTime As Long = DateTime.DateParse(s)
   Log(DateUtils.TicksToString(serverTime))
   Dim p As Period = DateUtils.PeriodBetweenInDays(DateTime.Now, serverTime)
   Log(p)
End Sub

Facilauto Juan · Nov 28, 2013

I'll try that. Thanks, Erel.

Android Question Date/time diff?

Facilauto Juan

Member

Erel

B4X founder

Facilauto Juan

Member

Erel

B4X founder

Facilauto Juan

Member

Similar Threads

Android Question Date/time diff?

Facilauto Juan

Member

Erel

B4X founder

Facilauto Juan

Member

Erel

B4X founder

Facilauto Juan

Member

Similar Threads

Privacy & Transparency

Privacy & Transparency