Pavel Ivanov wrote:
> Why this doesn't work?
>
> insert into table (creationdate, modifieddate, mytext, title)
> select date('now'), date('now'), "show text", "show title";
It is possible that, if you run this statement at just the wrong moment, the
two date('now') calls will produce different results. This may or may not
matter, but in case it does, you may want something like this instead:
insert into table (creationdate, modifieddate, mytext, title)
select now, now, 'show text', 'show title'
from (select date('now') as now);
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
