create table each_transaction(datetime int);
insert into each_transaction values( datetime('%s',
'now'));
this is how I create table and insert the
strftime('%s', 'now'). But when I did query with
sql3_plus.
sqlite3::reader reader=con.executereader("select *
from each_transaction;");
while(reader.read())
{cout << reader.getcolname(0) << ": " <<
reader.getstring(0) << endl; }
I get output like this:
datetime: � " <----- invalid
Any idea? coz If I change to
datetime('now','localtime');
everything is ok. I only cannot use strftime('%s',
'now') for "insert" statement.
I tried out the pre-compiled command-prompt sqlite but
doesn't faced with this problem. The sql_lite that i'm
using to do the above test was static lib compiled by
me using dev-cpp. I even tried out linking directly
with .dll but the result still the same, unexpected
output.
thakn you for reading and clarifying my mistake.
__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail
