From: | Bjørn T Johansen <btj(at)havleik(dot)no> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Strange? BETWEEN behaviour. |
Date: | 2016-10-20 11:51:34 |
Message-ID: | 20161020135134.1387b6ca@arch-btj.norsvin.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have the following SQL:
SELECT * from table WHERE date BETWEEN to_timestamp('20.10.2016 00:00:00','DD.MM.YYYY HH24:MI:SS') AND to_timestamp('20.10.2016 23:59:59','DD.MM.YYYY
HH24:MI:SS')
date is of type timestamp.
I was expecting to get all the records that had datepart = 20.10.2016 but I am not getting that..
What am I missing?
Regards,
BTJ
--
-----------------------------------------------------------------------------------------------
Bjørn T Johansen
btj(at)havleik(dot)no
-----------------------------------------------------------------------------------------------
Someone wrote:
"I understand that if you play a Windows CD backwards you hear strange Satanic messages"
To which someone replied:
"It's even worse than that; play it forwards and it installs Windows"
-----------------------------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | William Ivanski | 2016-10-20 12:02:14 | Re: Strange? BETWEEN behaviour. |
Previous Message | Jaisingkar, Piyush | 2016-10-20 09:42:21 | Re: Unnest an array in postgresql |