On Nov 26, 2018, at 14:16, Simon Slavin wrote:
>
> On 26 Nov 2018, at 9:09pm, Scott Perry wrote:
>
>> For Bill's purposes—investigating a copied, non-corrupt database—it would
>> probably be easiest to just convert from the Cocoa epoch to the Unix epoch
>> by updating all the columns that
On 26 Nov 2018, at 9:09pm, Scott Perry wrote:
> For Bill's purposes—investigating a copied, non-corrupt database—it would
> probably be easiest to just convert from the Cocoa epoch to the Unix epoch by
> updating all the columns that currently store Cocoa timestamps. Something
> like:
>
>
On Nov 20, 2018, at 12:41 PM, Jens Alfke wrote:
> On Nov 20, 2018, at 11:44 AM, Bill Hashman
> wrote:
>
>> The timestamp from iOS systems is not compliant with ISO 8601/Unix or other
>> common timestamps. It appears apple has their start date offset 31 years.
>
> Yes, the ‘epoch’ in
On Nov 20, 2018, at 12:41 PM, Jens Alfke wrote:
> On Nov 20, 2018, at 11:44 AM, Bill Hashman
> wrote:
>
>> The timestamp from iOS systems is not compliant with ISO 8601/Unix or other
>> common timestamps. It appears apple has their start date offset 31 years.
>
> Yes, the ‘epoch’ in
> On Nov 20, 2018, at 21:49, Thomas Kurz wrote:
>
>> (Does SQL itself have a numeric timestamp type, or explicitly endorse the
>> POSIX epoch for numeric timestamps?)
>
> SQL has an explicit TIMESTAMP type since SQL-92, one thing that I'm heavily
> missing in SQlite ;-)
DATE '1998-12-25’ &
> (Does SQL itself have a numeric timestamp type, or explicitly endorse the
> POSIX epoch for numeric timestamps?)
SQL has an explicit TIMESTAMP type since SQL-92, one thing that I'm heavily
missing in SQlite ;-)
___
sqlite-users mailing list
> On Nov 20, 2018, at 11:44 AM, Bill Hashman
> wrote:
>
> The timestamp from iOS systems is not compliant with ISO 8601/Unix or other
> common timestamps. It appears apple has their start date offset 31 years.
Yes, the ‘epoch’ in Apple’s own APIs (CoreFoundation, Foundation) is 1/1/2001,
Short version of my opinion for this is: An application can store whatever it
wants in a database. The job of the database software, or the ODBC software is
to give you "what they actually stored", not to give you "what they meant by
it." So putting this at the ODBC driver level would be bad.
8 matches
Mail list logo