On Tue, Oct 23, 2018 at 5:38 AM Lutz Horn <[email protected]> wrote: > > Hi, > > I am looking for a way to select all timestamps that are "today" in an > index friendly way. This select should not depend on the concrete value > of "today". >
Per TFM, https://www.postgresql.org/docs/10/static/datatype-datetime.html on table 8.13, you can use special input values: SELECT * FROM t WHERE ts >= 'today'::timestamp AND ts < 'tomorrow'::timestamp; HTH, -- Mike Rylander | Executive Director | Equinox Open Library Initiative | phone: 1-877-OPEN-ILS (673-6457) | email: [email protected] | web: http://equinoxinitiative.org
