Hello!
В сообщении от Tuesday 17 February 2009 22:01:38 Jay A. Kreibich написал(а):
> > I think you can to try
> >
> > 1. Replace date date, time time to single REAL field:
> > date REAL NOT NULL DEFAULT (julianday('now'))
>
> That's not going to do what you think it is going to do.
>
> DEFAULTs are *literals*, not expressions.
It's work.
2008-Jun-27 14:59:02 by drh:
Works already. Correct syntax is:
CREATE TABLE record(
sometext TEXT NOT NULL,
timestamp REAL NOT NULL DEFAULT (julianday('now'))
);
Best regards, Alexey.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
