Home select query with date in postgres sql
Reply: 0

select query with date in postgres sql

user552
1#
user552 Published in April 26, 2018, 1:43 pm

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.

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.36243 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO