Re: Select "todays" timestamps in an index friendly way

From: "Lutz Horn" <lutz(dot)horn(at)posteo(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Select "todays" timestamps in an index friendly way
Date: 2018-10-23 10:19:49
Message-ID: 20181023101949.GC21523@lutz-pc.ecm4u.intra
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Lutz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2018-10-23 10:41:01 Re: Select "todays" timestamps in an index friendly way
Previous Message Lutz Horn 2018-10-23 10:12:40 Re: Select "todays" timestamps in an index friendly way