# PostgreSQL Data Types: Date and Time Processing

DevFeed: [PostgreSQL Data Types: Date and Time Processing](<https://devfeed.tech/articles/postgresql-data-types-date-and-time-processing-34589.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2018/04/postgresql-data-types-date-and-time-processing/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2018-04-13T11:35:47Z

Content type: tutorial

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [DateTime](<https://devfeed.tech/topics/datetime.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Statistics](<https://devfeed.tech/topics/statistics.md>), [data](<https://devfeed.tech/topics/data.md>), [Git](<https://devfeed.tech/topics/git.md>)

Tags: [data](<https://devfeed.tech/tags/data.md>), [git](<https://devfeed.tech/tags/git.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [reporting](<https://devfeed.tech/tags/reporting.md>), [sql](<https://devfeed.tech/tags/sql.md>), [statistics](<https://devfeed.tech/tags/statistics.md>), [time](<https://devfeed.tech/tags/time.md>)

## AI overview

This tutorial explains how PostgreSQL date and time processing functions can be used with timestamp-with-time-zone data. Using Git history loaded into a commitlog table, it demonstrates retrieving recent records, producing time-based reports, comparing activity by project and weekday, and calculating timestamp differences and percentiles.

## Source excerpt

Continuing our series of PostgreSQL Data Types today we're going to introduce date and time based processing functions. Once the application's data, or rather the user data is properly stored as timestamp with time zone, PostgreSQL allows implementing all the processing you need to. In this article we dive into a set of examples to help you get started with time based processing in your database. Can we boost your reporting skills?