Re: Query not producing expected result
| От | Chuck Martin |
|---|---|
| Тема | Re: Query not producing expected result |
| Дата | |
| Msg-id | CAFw6=U3wV3NDt3c8sqHiE4QLRufy3s8d21BaLdkRLpPNUEh9ww@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Query not producing expected result (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: Query not producing expected result
|
| Список | pgsql-general |
Thanks, guys. It should have been obvious to me, but wasn't.
I found the correct result was returned with either
AND event.DateTime <= 'May-1-2019 24:00'
or
AND event.DateTime::date <= 'May-1-2019'
The latter seems best.
Chuck Martin
Avondale Software
On Wed, May 1, 2019 at 12:41 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Chuck Martin <clmartin@theombudsman.com> writes:
> I need help figuring out why a query is not returning the records I expect
> it to. I'm searching on a DateTime column (timestamp without time zone -
> not nullable). The query includes:
> AND event.Primaryresp_fkey = 5000011 AND event.DateTime <= 'May-1-2019'
> AND event.EventDone < 1
> This does not return a record that has a DateTime value "May 1, 2019 9:52
> AM".
Well, no, since the implied value of the constant is 'May-1-2019 00:00'.
If you only want 1-day precision of the comparison, maybe you should cast
or truncate the timestamp down to date.
regards, tom lane
В списке pgsql-general по дате отправления: