On Sep 15, 2013, at 12:53 AM, Kees Nuyt <k.n...@zonnet.nl> wrote: > 3) If an SQL-statement generally contains more than one reference > to one or more <datetime value function>s, then all such ref- > erences are effectively evaluated simultaneously.
FWIW, Oracle concurs: "All of the datetime functions that return current system datetime information, such as SYSDATE, SYSTIMESTAMP, CURRENT_TIMESTAMP, and so forth, are evaluated once for each SQL statement, regardless how many times they are referenced in that statement." http://docs.oracle.com/cd/B28359_01/server.111/b28286/functions001.htm _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
