On Sep 28, 2011, at 2:26 PM, Roger Andersson wrote:
> On 09/28/11 21:10, Black, Michael (IS) wrote:
>>
>> 'scuse me....I was wrong (again)...I guess strftime does return an
>> integer....seems to me that belies the name as it's a mismatch to the unix
>> function.
>>
>>
> ?
> SQLite version 3.7.8 2011-09-19 14:49:19
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
> sqlite> select typeof(strftime('%s','now','localtime'));
> text
>
Perhaps, but I have inserted that in my table where the column is INTEGER.
sqlite> SELECT typeof(u_downloaded_on) FROM uris LIMIT 1;
integer
--
Puneet Kishor
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
