Re: [sqlite] bogus output for strftime('%s', 'now') ermm..

2005-02-01 Thread Jay
Did you try this? create table each_transaction(datetime text); insert into each_transaction(datetime) values(datetime('now')); D:\temp\convention>sqlite3 test.db SQLite version 3.0.8 Enter ".help" for instructions sqlite> create table each_transaction(datetime text); sqlite> insert into

Re: [sqlite] bogus output for strftime('%s', 'now') ermm..

2005-02-01 Thread teoh
nope. reader.getint32(0) will return 0 i tried changed datetime to "text" and did the query by getsring(0) and i get same invalid output output: รก " i still cant use strftime('%s', 'now') . --- [EMAIL PROTECTED] wrote: > teoh <[EMAIL PROTECTED]> writes: > > > create table