RE: [sqlite] default CURRENT_TIMESTAMP status?

Indeed. Searching the source, this has never been implemented. > > Hrm. In that case, perhaps I should say "The documentation > is broken": > > [ http://www.sqlite.org/lang.html#createtable ] > > The DEFAULT constraint specifies a default value to use when > doing an INSERT. The

Re: [sqlite] default CURRENT_TIMESTAMP status?

On Tue, 18 Jan 2005, Kurt Welgehausen wrote: ... CURRENT_TIMESTAMP is broken ... I don't think it's broken; I think it's just never been implemented. Hrm. In that case, perhaps I should say "The documentation is broken": [ http://www.sqlite.org/lang.html#createtable ] The DEFAULT

Re: [sqlite] default CURRENT_TIMESTAMP status?

> ... CURRENT_TIMESTAMP is broken ... I don't think it's broken; I think it's just never been implemented. > ... best way to substitute for it ... It's simple to write a trigger to do almost the same thing.