SQLite Forum

Serious problems with STORED columns
Login
Quick question.

According to the [Generated Columns Page](https://www.sqlite.org/gencol.html#limitations) section 2.3.3

> The expression of a generated column may only reference constant literals and columns within the same row, and may only use scalar deterministic functions. The expression may not use subqueries, aggregate functions, window functions, or table-valued functions.

So my question is: Is datetime() considered deterministic? Or should there have been an error when creating that table which said "deterministic functions only please"?