Skip to content

Instantly share code, notes, and snippets.

@ratpik

ratpik/postgres_timestamp_range_query.sql

Created November 17, 2020 14:42
Show Gist options
  • Save ratpik/cef28494e4abe668c4531be0f71f49b9 to your computer and use it in GitHub Desktop.
Save ratpik/cef28494e4abe668c4531be0f71f49b9 to your computer and use it in GitHub Desktop.
Download ZIP
Timestamp Range Query MySQL
Raw
postgres_timestamp_range_query.sql
select * from mytable where category LIKE 'search%' AND client_timestamp BETWEEN timestamp '2020-11-17T00:00:00' AND timestamp '2020-11-18T09:59:29'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment