SQLite Forum

Can DEFAULT be the only possible value?
Login
Great idea but doesn't seem to work with datetime.

```
CREATE TABLE log(dt GENERATED ALWAYS AS (datetime('now','localtime')) STORED,event);
INSERT INTO log(event) VALUES('xxx');
```

gives:

`Error: non-deterministic use of datetime() in a generated column`