Subject | Re: [firebird-support] SELECT ... WHERE ... BETWEEN using TIMESTAMP felds |
---|---|
Author | Dimitry Sibiryakov |
Post date | 2009-04-20T12:54:05Z |
> DATA_ORA TIMESTAMP DEFAULT CURRENT_TIMESTAMP,Tell me, how you managed to insert 'POWER LINE KRAUN 200MBPS BRIDGE
>
> 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?
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.