O'Reilly logo

PostgreSQL Developer's Handbook by Hans-Jürgen Schönig, Ewald Geschwinde

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required