Re: date_trunc function in interval version
| От | Pavel Stehule |
|---|---|
| Тема | Re: date_trunc function in interval version |
| Дата | |
| Msg-id | CAFj8pRA5F7tHGfxCf3+6XcvQDN2hzM+nFhX1t81JGfBL3Kq64A@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: date_trunc function in interval version (Pavel Stehule <pavel.stehule@gmail.com>) |
| Список | pgsql-hackers |
so 23. 12. 2023 v 13:33 odesílatel Pavel Stehule <pavel.stehule@gmail.com> napsal:
Hipá 22. 12. 2023 v 23:25 odesílatel Przemysław Sztoch <przemyslaw@sztoch.pl> napsal:In my opinion date_trunc is very good name.
Truncated data is timestamp type, not interval.
First parameter has same meaning in original date_trunc and in my new version.
New version provides only more granularity.ok, I miss it.
I was confused - I am sorry, I imagined something different. Then the name is correct.
Regards
Pavel
Pavel Stehule wrote on 12/22/2023 8:43 PM:Hipá 22. 12. 2023 v 20:26 odesílatel Przemysław Sztoch <przemyslaw@sztoch.pl> napsal:Hello.
There is date_trunc(interval, timestamptz, timezone) function.
First parameter can be '5 year', '2 month', '6 hour', '3 hour', '15 minute', '10 second' etc.should not be named interval_trunc instead? In this case the good name can be hard to choose, but with the name date_trunc it can be hard to find it.RegardsPavel--
Przemysław Sztoch | Mobile +48 509 99 00 66--
Przemysław Sztoch | Mobile +48 509 99 00 66
В списке pgsql-hackers по дате отправления: