select from postgres table where time now is greater than a day code example Example: postgre query date SELECT * FROM data WHERE date = '2020-12-21'