• 

  Time and Related Data Types in PostgreSQL | Cockroach Labs

  

  cockroachlabs.com

  The Intricacies of Time and Related Data Types in Postgres — As part of Cockroach Labs work in making CockroachDB even more compatible with Postgres (the goal is to be a drop-in replacement) they’ve spent a lot of time getting time right.. and have learnt a lot along the way.

  engineering

  • Add  

  1

Appears in lists (1)

• Issue 358 - A deep dive into various types of locks in Postgres

More like this (3)

• 

  “allballs” is a valid PostgreSQL time literal for “midnight UTC”

  

  postgresql.org

  • Read
  • Add  

  
• Representing Dates, Times and Intervals in PostgreSQL - pgDash

  

  pgdash.io

  Representing Dates, Times and Intervals in Postgres — Postgres comes with a bunch of built-in date...

  Representing Dates, Times and Intervals in Postgres — Postgres comes with a bunch of built-in date and time related data types. But why should you use them over strings or integers? Here’s an overview looking at the why, plus advice on how to do so effectively.

  • Read
  • Add  

  
• 

  PostgreSQL: now() vs. 'NOW'::timestamp vs. clock_timestamp() - Cybertec

  

  cybertec-postgresql.com

  now() vs. 'NOW'::timestamp vs. clock_timestamp() — Ah, dates and times, the bane of any app developer’s...

  now() vs. 'NOW'::timestamp vs. clock_timestamp() — Ah, dates and times, the bane of any app developer’s life.. and database users too :-) This post looks at the different flavors of working with the current time in Postgres.

  • Read
  • Add