Subject | Problems selecting on Timestamp. |
---|---|
Author | canacourse |
Post date | 2011-11-08T18:45:26Z |
How may I select items older than a certain epoch from a timestamp column? For example I have many records in a column using timestamp as the type and containing records such as:-
'5.11.2011 23:34:21'
'5.11.2011 08:34:00'
'6.11.2011 19:55:45'
'7.11.2011 15:23:26'
However these queries produce no results even thought I can see records older then I'm looking for in the table
select * FROM ENTRIES WHERE ENTRYTIME < '6/11/2011 08:34:26';
or
select * FROM ENTRIES WHERE ENTRYTIME < '6.11.2011 08:34:26';
Firebird 2.6.5 Dialect 3
'5.11.2011 23:34:21'
'5.11.2011 08:34:00'
'6.11.2011 19:55:45'
'7.11.2011 15:23:26'
However these queries produce no results even thought I can see records older then I'm looking for in the table
select * FROM ENTRIES WHERE ENTRYTIME < '6/11/2011 08:34:26';
or
select * FROM ENTRIES WHERE ENTRYTIME < '6.11.2011 08:34:26';
Firebird 2.6.5 Dialect 3