I am converting from SQLite to PostgreSQL and have found that working with dates is not working! I have the following code which does not error, but also does not provide the expected results (for which I know there are at least 5 records.
SELECT * FROM transaction_access WHERE sql_date_time = '2019-05-23%' ORDER BY sql_date_time DESC
Even if I try this in the SQL part of pgAmin3 I get no errors, but no records. The field data type is
sql_date_time timestamp without time zone,
What am I doing wrong?