PostgreSQL - compare date values

In this article, we would like to show you how to compare date values in PostgreSQL.

Quick solution:

xxxxxxxxxx

SELECT *

FROM "table_name"

WHERE "date_column_name" <= 'yyyy-mm-dd';

Note:

You can replace the <= operator with any other comparison operator.

To show how to compare date values, we will use the following table:

Note:

At the end of this article you can find database preparation SQL queries.

In this example, we will display all the dates before 2000-01-04.

Query:

xxxxxxxxxx

SELECT *  

FROM "dates" 

WHERE "date" < '2000-01-04';

Output:

In this example, we will select all the rows from 2000-01-04 inclusive and display them without time using DATE() function (yyyy-mm-dd format only).

Query:

xxxxxxxxxx

SELECT "date"

FROM "dates"

WHERE "date" <= '2000-01-04';

Output:

create_tables.sql file:

xxxxxxxxxx

create TABLE "dates"(

    "id" SERIAL PRIMARY KEY,

    "date" DATE

);

insert_data.sql file:

xxxxxxxxxx

insert into "dates"

    ("date") 

VALUES 

    ('2000-01-01'),

    ('2000-01-02'),

    ('2000-01-03'),

    ('2000-01-04'),

    ('2000-01-05'),

    ('2000-01-06');