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