"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

Reply via email to