You should read http://www.sqlite.org/datatype3.html , may help you.
On Tue, Nov 24, 2009 at 10:48, Virgilio Fornazin <virgilioforna...@gmail.com > wrote: > SQL does not have a specific datetime field type and also does not store it > in binary format. > You should perform the data type conversions by yourself. > > > On Tue, Nov 24, 2009 at 09:50, Renato Oliveira > <ren...@sincronica.com.br>wrote: > >> Hello, I'm new to SQLite, and need a query to convert a number of int >> format to format date and date format to format int. >> In PostGres the query is as follows: >> >> SELECT ((((14652:: bit (16))>> 9): int + 1980) | | '-' | | >> ((14652:: bit (16) & B'0000000111100000 ')>> 5):: int | |' - '| | >> (14652:: bit (16) & B'0000000000011111 '):: int):: date; >> >> Is there a book for beginners in SQLite? >> >> Hugs >> >> Renato S. Oliveira >> Sincronica Sistemas Integrados >> +55 11 2539 0544 / 0545 >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
