Subject Problems selecting on Timestamp.
Author canacourse
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