Skip to content

Instantly share code, notes, and snippets.

@ieure

ieure/gist:782495cc5a4b954565ad

Created June 10, 2015 15:21
Show Gist options
  • Save ieure/782495cc5a4b954565ad to your computer and use it in GitHub Desktop.
Save ieure/782495cc5a4b954565ad to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
<SchemaCzar> CHALLENGE QUESTION: what is the precision of a timestamp without time zone ?
<ieure> SchemaCzar, Nanoseconds.
<ieure> SchemaCzar, I know this because JVM timestamps only support milliseconds. So if you have a psql TS column and move that data into the JVM, you lose precision.
<ieure> And this caused Bugs
<SchemaCzar> and I'm trying to use that point to convince my team to convert from timestamp with no time zone to timestamp with time zone
<ieure> SchemaCzar, You're the fucking Schema Czar. Just change it.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment