Subject | Re: [firebird-support] SELECT ... WHERE ... BETWEEN using TIMESTAMP felds |
---|---|
Author | Dimitry Sibiryakov |
Post date | 2009-04-20T13:20:02Z |
> CREATE TABLE LSV (And why do you think that data, inserted into TABLE_NAME, filtered in
> 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
*LSV* and selected from *ART* must have any consistence?
SY, SD.