iOS Question How to convert from DATETIMEOFFSET to Ticks

[stingrae]

Hi,

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

{
  "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:

  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.

 

[Erel]

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

Always post the error message...

DateTime.DateFormat = "yyyy-MM-dd'T'HH:mm:ssZ"

https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html

 

[stingrae]

Always post the error message...

Sorry ... Will do from now on.

And Thanks