Skip to content

Instantly share code, notes, and snippets.

@gadelkareem

gadelkareem/postgres_solr.sql

Created April 5, 2018 00:40
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 gadelkareem/b86e52b95e6086a85c39cf640ba9bf68 to your computer and use it in GitHub Desktop.
Save gadelkareem/b86e52b95e6086a85c39cf640ba9bf68 to your computer and use it in GitHub Desktop.
Download ZIP
Convert postgres timestamp to solr date format
Raw
postgres_solr.sql
SELECT to_char('2018-02-28 18:48:11.196+00'::timestamp, 'YYYY-MM-DD"T"HH24:MI:SSZ')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment