On Wed, Jan 7, 2015 at 3: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. > > select DateTime(base, 'unixepoch') from dates > > where there is a single row and base = 0x49962d2 > Paul > The processing of hex integers is performed at statement preparation time. So the internal representation it just that of an integer, thus anything previously stored as text that just happens to be in hex integer format. In other words, '0x1234ABCD' (with quotes) is not the same as 0x1234ABCD (sans quotes). -- Scott Robison _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
