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