If you are trying to purge a huge database and it is not live, another
possibility is to attach a new blank database and SELECT into it. This way
you don't have to waste time with VACUUM.
On Mon, Sep 24, 2012 at 10:04 AM, Clemens Ladisch <clem...@ladisch.de>wrote:
> Don Goyette wrote:
> > > With 60*60*24 seconds per day, the number of days since the Unix epoch
> is:
> > > sqlite> select strftime('%s', '2012-05-22') / (60*60*24);
> > > 15482
> >
> > The timestamp in the tables I'm reading is not in the format of
> > '2012-05-22'.
>
> Sorry, my explanations were not clear enough. This is not yet the
> conversion; here I just determined the number of days between the Unix
> epoch and your example timestamp.
>
> That was used to derive the actual conversion formula that you wanted:
>
> > > (excel_timestamp - 25569) * (60*60*24)
>
> And this was just a check of the formula, using your example timestamp:
>
> > > > select datetime((41051.3958333334 - 25569) * (60*60*24),
> 'unixepoch');
> > > 2012-05-22 09:30:00
>
>
> Regards,
> Clemens
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
