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