Re: [sqlite] Simple data conversion in SQLite - please help

2014-01-24 Thread Klaas V 
On Jan 22, 2014, at 8:21 AM, Richard Hipp  wrote:

> I seem to recall seeing some SMS databases off of an iPhone that used unix
> timestamps for the date/time.  That would be seconds since 1970.  You can
> use the 'unixepoch' modifier on the date functions within SQLite to do
> the conversion, if you want.

That's the normal epoch point zero. There are systems starting on January 1, 
1904
Perhaps other dates are used as well.

Klaas `Z4us` V
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Simple data conversion in SQLite - please help

2014-01-22 Thread Ward Willats 

On Jan 22, 2014, at 8:21 AM, Richard Hipp  wrote:

> I seem to recall seeing some SMS databases off of an iPhone that used unix
> timestamps for the date/time.  That would be seconds since 1970.  You can
> use the 'unixepoch' modifier on the date functions within SQLite to do
> the conversion, if you want.


Yeah, that's what we do in our iOS apps. Try  "select datetime( field, 
'unixepoch' ) from table"

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Simple data conversion in SQLite - please help

2014-01-22 Thread Richard Hipp 
On Wed, Jan 22, 2014 at 10:46 AM, Kees Nuyt  wrote:

> On Wed, 22 Jan 2014 12:42:27 -, "DJ Small Paul" <
> i...@djsmallpaul.co.uk> wrote:
>
> >Hi everyone,
> >
> >
> >
> >I hope this is an easy one for you!
> >
> >
> >
> >I've got an SQLite 3 database from an iphone app. I've pulled a table out
> >and the "date" column is in double binary - How do I see it as the actual
> >"date"??
>
> It is probably in Julianday format:
>
> http://sqlite.org/lang_datefunc.html
>
> perhaps with an Apple specific offset.
> Aplle sometimes uses its own perception of day zero,
> however, I forgot what date that was.
> Some simple experiments will tell you.
>
> I hope this helps.
>
>
I seem to recall seeing some SMS databases off of an iPhone that used unix
timestamps for the date/time.  That would be seconds since 1970.  You can
use the 'unixepoch' modifier on the date functions within SQLite to do
the conversion, if you want.

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Simple data conversion in SQLite - please help

2014-01-22 Thread Kees Nuyt 
On Wed, 22 Jan 2014 12:42:27 -, "DJ Small Paul"  
wrote:

>Hi everyone,
>
> 
>
>I hope this is an easy one for you!
>
> 
>
>I've got an SQLite 3 database from an iphone app. I've pulled a table out
>and the "date" column is in double binary - How do I see it as the actual
>"date"??

It is probably in Julianday format:

http://sqlite.org/lang_datefunc.html

perhaps with an Apple specific offset.
Aplle sometimes uses its own perception of day zero,
however, I forgot what date that was. 
Some simple experiments will tell you.

I hope this helps.

-- 
Groet, Cordialement, Pozdrawiam, Regards,

Kees Nuyt

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users