PostgreSQL - How to search by a date from datetime fields?

Search and show rows with a specific date

You have table actor with the column last_update type timestamp.

You want to search and show only the records with a specific date, let’s say '2017-02-15'

SELECT
	*
FROM
	actor
WHERE
	last_update >= '2017-02-15'::date
	AND last_update < ('2017-02-15'::date + '1 day'::interval);

Or in another form:

SELECT
	*
FROM
	actor
WHERE
	last_update >= CAST('2017-02-15' AS DATE)
	AND last_update < (CAST('2017-02-15' AS DATE) + CAST('1 day' AS INTERVAL));

---

Need a good GUI Tool for PostgreSQL? TablePlus is a modern, native tool with an elegant UI that allows you to simultaneously manage multiple databases such as MySQL, PostgreSQL, SQLite, Microsoft SQL Server and more.


Download TablePlus for Mac.

Not on Mac? Download TablePlus for Windows.

On Linux? Download TablePlus for Linux

Need a quick edit on the go? Download TablePlus for iOS.