Android Question Date/time diff?

[Facilauto Juan]

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]

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

 

[Facilauto Juan]

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]

This should help you get started:

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]

I'll try that. Thanks, Erel.