RE: Where condition doesn't work as expected

Ken Benson | ken @ infowerks-dot-com

-----Original Message-----
From: William Colls <william@williamcollsassoc.ca> 
Sent: Saturday, February 8, 2020 2:40 PM
To: pgsql-novice@lists.postgresql.org
Subject: Where condition doesn't work as expected
>>>>-----Original Message-----
>>>>From: William Colls <william@williamcollsassoc.ca> 
>>>>Sent: Saturday, February 8, 2020 2:40 PM
>>>>To: pgsql-novice@lists.postgresql.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
datetimefield begins with 2019. I suspect that I should be using timestamp values, but I can't figure out how to cast
thedatetime 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
datetimefield begins with 2019. I suspect that I should be using timestamp values, but I can't figure out how to cast
thedatetime field value to a timestamp.
 

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

Thanks for your time.

William.