Hmm - why can't I get that to work when the hex value is stored in a column, i.e.
select DateTime(base, 'unixepoch') from dates where there is a single row and base = 0x49962d2 Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite http://sandersonforensics.com/forum/content.php?168-Reconnoitre - VSC processing made easy On 7 January 2015 at 22:27, Petite Abeille <petite.abei...@gmail.com> wrote: > >> On Jan 7, 2015, at 11:08 PM, Paul Sanderson <sandersonforens...@gmail.com> >> wrote: >> >> Is this possible? > > With a contemporary version of SQLite, yes: > > sqlite> select DateTime(77161170, 'unixepoch'); > 1972-06-12 01:39:30 > > sqlite> select DateTime(0x49962d2, 'unixepoch'); > 1972-06-12 01:39:30 > > > _______________________________________________ > 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
