Skip to content

Instantly share code, notes, and snippets.

@JorgeMichelena

JorgeMichelena/using_datetimes.sql Secret

Created September 19, 2022 21:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save JorgeMichelena/52b2492e72d00f65d3583a6f7c3bf167 to your computer and use it in GitHub Desktop.
Save JorgeMichelena/52b2492e72d00f65d3583a6f7c3bf167 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
using_datetimes.sql
SELECT "targets_target"."id", "targets_target"."user_id",
...
"targets_target"."created_at", "targets_target"."updated_at"
FROM "targets_target"
WHERE (("targets_target"."created_at" AT TIME ZONE \'UTC\')::date = \'2022-08-08\'::date
AND EXTRACT(\'hour\' FROM "targets_target"."created_at" AT TIME ZONE \'UTC\') = 14
AND EXTRACT(\'minute\' FROM "targets_target"."created_at" AT TIME ZONE \'UTC\') = 10) LIMIT 21
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment