杰 张 wrote: > Hi,all > I created a DATETIME field in a table. So how do it automatically INSERT > INTO datetime data to the DATETIME field? Thank you so much! > > > zhangjie > > > --------------------------------- > 雅虎1G免费邮箱百分百防垃圾信 If you have a DATETIME field as an ISO date/time, insert it into Sqlite using the julianday function
INSERT INTO JUNK VALUES ('AAA', julianday('2006-12-12 05:06:00')); Ypu will then have a floating point number stored. It holds both date and time.