Subject Re: [firebird-support] SELECT ... WHERE ... BETWEEN using TIMESTAMP felds
Author Dimitry Sibiryakov
> CREATE TABLE LSV (
> INSERT INTO TABLE_NAME (ART_CODICE, DESCRIZIONE1, DATA_ORA, PREZZO) VALUES
> ('CDC.WD.86', 'HDD ESTERNO WD MY BOOK ESSENTIAL 1TB', '20-APR-2009
> 13:56:57', 105);
>
> Select Art.DATA_ORA,Art.Codice,Art.Descrizione1,Lsv.Prezzo from Lsv,ART
> where LSV.ART_CODICE=ART.CODICE
> AND LSV.DATA_ORA between CAST('03/20/2009 00:01:00' AS TIMESTAMP) and
> CAST('04/20/2009 23:59:00' AS TIMESTAMP)
> ORDER BY DATA_ORA

And why do you think that data, inserted into TABLE_NAME, filtered in
*LSV* and selected from *ART* must have any consistence?

SY, SD.