> On Jan 7, 2015, at 11:35 PM, Paul Sanderson <sandersonforens...@gmail.com>
> wrote:
>
> Hmm - why can't I get that to work when the hex value is stored in a
> column, i.e.
Most likely your data is stored as text, e.g.:
with
DataSet
as
(
select '0x49962d2' as value
union all
select 0x49962d2 as value
)
select DataSet.value,
DateTime( DataSet.value, 'unixepoch' ) as date,
typeof( DataSet.value ) as type
from DataSet
value|date|type
0x49962d2||text
77161170|1972-06-12 01:39:30|integer
To quote the nice manual:
"hexadecimal integer notation is only understood by the SQL language parser,
not by the type conversions routines”:
https://www.sqlite.org/lang_expr.html#hexint
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
