rgwozdz/tim-date.sql

Created September 1, 2017 20:41

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/rgwozdz/271d424f2149f676d0254cecfcc8a2a0.js"></script>
Save rgwozdz/271d424f2149f676d0254cecfcc8a2a0 to your computer and use it in GitHub Desktop.

Download ZIP

Compare timestamp to date in Postgres

Raw

tim-date.sql

	SELECT *
	FROM table
	WHERE update_date >= '2013-05-03'::date
	AND update_date < ('2013-05-03'::date + '1 day'::interval);

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment