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.
Pavel Stehule wrote on 12/22/2023 8:43 PM:
Hi
pá 22. 12. 2023 v 20:26 odesílatel Przemysław Sztoch
<przemys...@sztoch.pl <mailto:przemys...@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.
Regards
Pavel
--
Przemysław Sztoch | Mobile +48 509 99 00 66
--
Przemysław Sztoch | Mobile +48 509 99 00 66