Subject Re: [firebird-support] SELECT ... WHERE ... BETWEEN using TIMESTAMP felds
Author Dimitry Sibiryakov
> DATA_ORA TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
>
> INSERT INTO TABLE_NAME (ART_CODICE, DESCRIZIONE1, DATA_ORA, PREZZO) VALUES
> ('25-OCT-2008 05:18:40', 'CDC.KR.XQ', 'POWER LINE KRAUN 200MBPS BRIDGE
> HOMEPLUG', 65);
>
> I don't have to retrieve first two lines?
> Any idea?

Tell me, how you managed to insert 'POWER LINE KRAUN 200MBPS BRIDGE
HOMEPLUG' into timestamp field DATA_ORA?
As to results of your query - DATA_ORA in them definitely isn't
timestamp because 25/10/2009 isn't a valid date. Besides, it is selected
from table different to which limits are put on.

SY, SD.