Hello,
I have noticed a problem in SQLite 3.20.1 for a simple operation based
on strftime('%s').
With SQLite 3.20.1 and 3.6.18
sqlite> select (strftime('%s', '2017-10-11 10:04:43') + 300) <
strftime('%s', '2017-10-11 10:04:43');
1
If I use the CAST operator on the second member, it works
sqlite> select
(strftime('%s', '2017-10-11 10:04:43') + 300) < CAST(strftime('%s',
'2017-10-11 10:04:43') as decimal);
0
If I use the following query, it works too:
sqlite> select
(strftime('%s', '2017-10-11 10:04:43') + 300 - strftime('%s',
'2017-10-11 10:04:43')) < 0;
0
on SQlite 2.8, the operator < with strftime('%s') works.
Any idea if it is the expected behavior?
Thanks,
Best Regards,
Eric
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
