Tag: date
PostgreSQL: mapping timestamps (date_bin)
date_bin and timestamps in PostgreSQL Date and time are relevant to pretty much every PostgreSQL application. A new function was added to PostgreSQL 14 to solve a problem which has caused challenges for many users out there over the years: How can we map timestamps to time bins? The function is called date_bin. What people […]
Read more
Time in PostgreSQL: The simple way
Time is one of those unloved topics every programmer has already dealt with. Have you ever written a routine heavily depending on time calculations in C, Python, PHP, Perl, or any other language? I am sure you have fallen in love with time management as much as I did. When it comes to processing time, […]
Read more