>So is "julianday('now')" non-deterministic while "julianday()" _is_ >deterministic? That seems a little weird considering they're the same >thing... right?
Yes. Same as "datetime(julianday(), '+1 day')" and datetime(datetime(), '+1 day') are deterministic but "datetime('now', '+1 day')" is not even though they all have the same result. -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users