doo/SQLite3-WinRT — pull request #27 by milgner (2012-07-03 13:24:54+00:00)
Title: Support Timestamps and 64bit Integers

Store dates from Javascript in a unix-epoch friendly manner.

NOTE: Javascript has millisecond precision while a classic unix timestamp only supports seconds. To achieve maximum compatibility between dates stored and retrieved in JavaScript, I opted to store the dates in millisecond-precision. So if you want to do date calculations in your SQL, you have to divide by 1000 and specify the 'unixepoch' modifier.

Example: SELECT DATETIME(my_date_field/1000, 'unixepoch', '+3 days') FROM my_table;