RE: Where condition doesn't work as expected

Ken Benson | ken @ infowerks-dot-com

-----Original Message-----
From: William Colls <william(at)williamcollsassoc(dot)ca>
Sent: Saturday, February 8, 2020 2:40 PM
To: pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Where condition doesn't work as expected
>>>>-----Original Message-----
>>>>From: William Colls <william(at)williamcollsassoc(dot)ca>
>>>>Sent: Saturday, February 8, 2020 2:40 PM
>>>>To: pgsql-novice(at)lists(dot)postgresql(dot)org
>>>>Subject: Where condition doesn't work as expected
>>>>
>>>>I have the following condition a select statement:
>>>>
>>>> WHERE "datetime" > '2019-03-31 23:59:59'
>>>>
>>>>datetime is a character field with data in the format YYYY-MM-DD HH:MM:SS. However it returns any line where the datetime field begins with 2019. I suspect that I should be using timestamp values, but I can't figure out how to cast the datetime field value to a timestamp.
>>>>

[Ken.B]
SELECT to_date('20170103','YYYYMMDD');
https://www.postgresqltutorial.com/postgresql-to_date/

>>>>Thanks for your time.
>>>>
>>>>William.
>>>>
I have the following condition a select statement:

 WHERE "datetime" > '2019-03-31 23:59:59'

datetime is a character field with data in the format YYYY-MM-DD HH:MM:SS. However it returns any line where the datetime field begins with 2019. I suspect that I should be using timestamp values, but I can't figure out how to cast the datetime field value to a timestamp.

[Ken.B]
SELECT to_date('20170103','YYYYMMDD');
https://www.postgresqltutorial.com/postgresql-to_date/

Thanks for your time.

William.