SQLite Forum

Timeline
Login

3 forum posts by user dab

2021-04-13
01:06 Reply: Please avoid all use of the "LL" suffix for long-long integer literals (artifact: 69cf3e96ec user: dab)
If it makes you feel better, I am also a VC6 user (for complex reasons).
You are not alone.
2020-05-04
02:02 Reply: Week numbers in queries (artifact: da825888f0 user: dab)
%z (timezone offset) is also missing.
2020-05-02
02:38 Reply: Week numbers in queries (artifact: 348b01e00b user: dab)
strftime() returns a string (i.e. text)

select '17' <> 17;

either cast or convert to integer

where  (0+strftime('%W', StartTime,'unixepoch', 'localtime')) <> 17