Hi All,
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)", , , );
sqlite3_exec(--, "insert into my_table (key,TEXT) values
(1,'new'), , , ) ;
sqlite3_exec(--, "select datetime(timeEnter,'localtime') from my_table
where key=1", , , );
the third one is displaying null.
sqlite3_exec(--, "select * from my_table where key=1", , , )
it is displaying key and tag values but not giving time so how can i get
the time of
specifice row when it was inserted in table.
as if i use
select datetime ('now', 'localtime') from my_table or
select strftime('%s','now','localtime') from my_table
it is giving current time. that i don't want. but i want the specific
row time when it was inserted.
am i missing something? as i want time at the time of insert, so how i
can get the that specific row time and date when this row was inserted.
suggest me any ideas..
thanks
Hari oum
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
