---
title: "Discussion on \"Test your SQL date filter with four boundary rows\" | Hashnode"
description: "Discussion on \"Test your SQL date filter with four boundary rows\". Catch missing last-day rows with a four-row PostgreSQL check. Compare BETWEEN, 23:59:59 and an exclusive next-month boundary."
url: "https://hashnode.com/posts/test-your-sql-date-filter-with-four-boundary-rows/6af9c21a46bf3e8f65435e9a"
---

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

Discussion

# [Test your SQL date filter with four boundary rows](https://sqlbrief.hashnode.dev/test-your-sql-date-filter-with-four-boundary-rows?utm_source=hashnode&utm_medium=feed)

Catch missing last-day rows with a four-row PostgreSQL check. Compare BETWEEN, 23:59:59 and an exclusive next-month boundary.

17h ago · 3 min read · sqlbrief.hashnode.dev  
Read the article

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

## Written by

[Aleks](https://hashnode.com/@aleks-sqlbrief)

@aleks-sqlbrief

  
[View profile](https://hashnode.com/@aleks-sqlbrief)

Building SQLBrief: hands-on SQL practice, from your first query to product analytics.

I'm Aleks, building SQLBrief. I write about SQL mistakes that change the meaning of a report, with examples you can run yourself. SQLBrief offers browser-based SQL practice in English and Russian.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
