sqlite: Sqlite Dates in a windows cordova application

mardi 23 juin 2015

I have a Cordova application on a windows phone 8.1 which utilises the MSOpenTech sqlplugin. I have a table which has a column:

"Modified_Date Date Not Null".

Now, when I save a date, say 1970/01/01 and retrieve the information this is returned:

/Date(0+0000)/

If I save the date 2015/06/16 and retrieve the information this is returned:

/Date(1434495600000+0100)/

It does not matter what format I use to save the dates (as long as its valid), the result always includes the +xxxx after the unix time stamp.

I can manipulate and parse the json dates, but can anyone tell me why I end up with a unix time stamp plus the +xxxx. What am I missing?

sqlite