On 1/29/2016 2:39 AM, Jean-Christophe Deschamps wrote:
> select cast(julianday('now') as int)
>
> should do what you want.
Note that the fractional part in Julian day represents time-of-day since
noon, not since midnight. The expression above will give different
values at 11am and 1pm (UTC) of the same day, and the same value at 11pm
and 1am of the same night. You would probably want
cast(julianday('now')-0.5 as int) or perhaps cast(julianday('now',
'localtime')-0.5 as int)
Personally, I prefer cast(strftime('%Y%m%d', 'now') as int) - in other
words, storing calendar dates as integers like 20160129.
--
Igor Tandetnik
