"Hari" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > i want to know the particular that time and date when a row is > inserted in a table. > as i am using sqlite3_exec() function for sql query. > my sql statements are like: > sqlite3_exec(--, "create table my_table (key INTEGER,tag TEXT, > timeEnter DATE)", , , );
create table my_table (key INTEGER,tag TEXT, timeEnter DATE DEFAULT CURRENT_TIMESTAMP); Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

