Hi El mar., 23 de oct. de 2018 a la(s) 05:41, Thomas Kellerer ( spam_ea...@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 > > > this is equally valid? where ts >= current_date cordialmente: Hellmuth Vargas