El mar., 23 de oct. de 2018 a la(s) 05:41, Thomas Kellerer (spam_eater@gmx.net) escribió:
Lutz Horn schrieb am 23.10.2018 um 12:19: > Hi Thomas, > > On Tue, Oct 23, 2018 at 12:11:55PM +0200, Thomas Kellerer wrote: >> I typically use: >> >> where ts >= date '2018-10-23' >> and ts < date '2018-10-23' + 1 > > But here the date is an explicit value. Francisco reworded my question: > >> if your definition of today is 'same value as now() when truncated to >> days' > > That's what I am (was, thanks to Francisco) looking for.
Then use current_date:
where ts >= current_date and ts < current_date + 1