select query with date in postgres sql

Question

I want to select records from date with a specific date. The problem is there is timestamp in the date. For example:

Table name : books
record 1 : 09-04-2018 10:31:00
record 2 : 09-04-2018 10:32:00
record 3 : 09-04-2018 10:33:00
record 4 : 10-04-2018 17:54:00
record 5 : 10-04-2018 18:49:01

I want to retrieve all records on date 09-04-2018 irrespective of the time.

select * from books where bookdate >= '09-04-2018' => This query is returning me all 5 records instead of 3.

Lukasz Szozda · Accepted Answer · 2018-04-16 17:45:35Z

1

I guess the problem is column/literal datatype:

select * from books where date::date >= '2018-04-09'::date;

" I try your query, still it returns all 5!"

Well, 2018-04-09 00:00:00 is smaller than all your 5 values.

edited Apr 16, 2018 at 17:45

answered Apr 16, 2018 at 17:41

Lukasz Szozda

181k26 gold badges278 silver badges326 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Alina Over a year ago

the datatype is timestamp. I try your query, still it returns all 5!!

Collectives™ on Stack Overflow

select query with date in postgres sql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related