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.