iOS Question How to convert from DATETIMEOFFSET to Ticks

stingrae

Member
Licensed User
Longtime User
Hi,

My SQL Server DB returns dates as per the following JSON:

B4X:
{
  "OrderID": 19,
  "OrderModifyTS": "2018-07-03T20:59:30+09:30", 
  "OrderRequestedTS": "2018-07-03T20:59:28+09:30",
  "OrderEstimatedTS": "2018-07-03T21:09:30+09:30"
}

But when I try the following B4i code, it crashes:

B4X:
  DateTime.DateFormat = "yyyy-MM-ddTHH:mm:ssz"
  Dim t As Int = DateTime.DateParse(MapOrders.Get("OrderRequestedTS"))
  Log(t)

I've searched here and tried different formats, but without luck.

Any advice?

Cheers.
 
Top