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'0000 ') 5):: int | |' - '| |
(14652:: bit
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.brwrote:
Hello, I'm new to SQLite, and need a query to convert a number of
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
Renato Oliveira 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'0000 ') 5):: int
On 11/24/09 14:08 , Igor Tandetnik itandet...@mvps.org wrote:
Renato Oliveira 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)
Jean-Denis Muys wrote:
On 11/24/09 14:08 , Igor Tandetnik itandet...@mvps.org wrote:
Renato Oliveira 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::