2016-01-29 16:23 GMT+01:00 Igor Tandetnik <igor at tandetnik.org>: > 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) >
?Yeah, I saw that. I went back to: date TEXT NOT NULL DEFAULT CURRENT_DATE ? > Personally, I prefer cast(strftime('%Y%m%d', 'now') as int) - in other > words, storing calendar dates as integers like 20160129. > ?That is a nice one. Maybe I'll change it again. ;-) -- Cecil Westerhof