Re: [sqlite] How do I create a DATETIME field?

Don't forget the date functions work on GMT not localtime. date('now', 'localtime'); gets your local time

Re: [sqlite] How do I create a DATETIME field?

杰 张 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

[sqlite] How do I create a DATETIME field?

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免费邮箱百分百防垃圾信