Re: [sqlite] Data converting

Jean-Denis Muys wrote: > On 11/24/09 14:08 , "Igor Tandetnik" 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: >>>

Re: [sqlite] Data converting

On 11/24/09 14:08 , "Igor Tandetnik" 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))>>

Re: [sqlite] Data converting

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

Re: [sqlite] Data converting

You should read http://www.sqlite.org/datatype3.html , may help you. On Tue, Nov 24, 2009 at 10:48, Virgilio Fornazin 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

Re: [sqlite] Data converting

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 wrote: > Hello, I'm new to SQLite, and need a query to convert a number

[sqlite] Data converting

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::