---
title: "Discussion on \"PostgreSQL Date & Time: The Working Engineer's Cheat Sheet\" | Hashnode"
description: "Discussion on \"PostgreSQL Date & Time: The Working Engineer's Cheat Sheet\". Dates are where \"it works on my machine\" queries go to die: DST shifts, month-end overflow, inclusive BETWEEN on timestamps, ISO-year mismatches. This is a fast, opinionated refresher for people who a"
url: "https://hashnode.com/posts/postgresql-date-time-the-working-engineer-s-cheat-sheet/6af3f8b706dea87c7016ad44"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [PostgreSQL Date & Time: The Working Engineer's Cheat Sheet](https://leeonscoding.hashnode.dev/postgresql-date-time-the-working-engineer-s-cheat-sheet?utm_source=hashnode&utm_medium=feed)

Dates are where "it works on my machine" queries go to die: DST shifts, month-end overflow, inclusive BETWEEN on timestamps, ISO-year mismatches. This is a fast, opinionated refresher for people who a

1d ago · 10 min read · leeonscoding.hashnode.dev  
Read the article

-   [#sql](https://hashnode.com/tag/sql)
-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#datetime](https://hashnode.com/tag/datetime)

## Written by

[Asfaq Leeon](https://hashnode.com/@leeonscoding)

@leeonscoding · Dhaka, Bangladesh

  
[View profile](https://hashnode.com/@leeonscoding)

Senior Software Engineer

## Responses

Markdown supported · ⌘↵ to post

No responses yet.