Chapter 17. Date Calculations

Working with dates is one of the most crucial tasks in the life of a computer programmer. Most operations can be done with the help of modules, but it is still important to have some basic knowledge about working with dates. This chapter guides you through the world of dates and time and shows you how to work with them efficiently in combination with PostgreSQL.

SQL and Dates

When dates are stored in databases, you will soon get in touch with PostgreSQL and simple date and time operations. SQL has to be used. In the next sections, you learn to work with SQL in dates.

SQL, Dates, and Time Zones

When dealing with time and dates, one of the most crucial aspects is time zones. In general, the world has been divided into 25 ...

Get PostgreSQL Developer's Handbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.