public inbox for [email protected]
help / color / mirror / Atom feedMissing date_trunc docs
2+ messages / 2 participants
[nested] [flat]
* Missing date_trunc docs
@ 2013-06-07 18:32 Eric Howe <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Eric Howe @ 2013-06-07 18:32 UTC (permalink / raw)
To: pgsql-docs
In table 9-27 of the 9.2 docs:
http://www.postgresql.org/docs/9.2/interactive/functions-datetime.html#FUNCTIONS-DATETIME-TABLE
There is an entry for date_trunc(text, timestamp) but no entry for date_trunc(text, interval). The full docs for date_trunc:
http://www.postgresql.org/docs/9.2/interactive/functions-datetime.html#FUNCTIONS-DATETIME-TRUNC
do mention both the timestamp and interval forms of date_trunc but that's easy to miss if you're just scanning the function lists.
Eric Howe
[email protected]
http://pieinsky.ca/
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Missing date_trunc docs
@ 2014-01-23 03:27 Bruce Momjian <[email protected]>
parent: Eric Howe <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Bruce Momjian @ 2014-01-23 03:27 UTC (permalink / raw)
To: Eric Howe <[email protected]>; +Cc: pgsql-docs
On Fri, Jun 7, 2013 at 11:32:14AM -0700, Eric Howe wrote:
> In table 9-27 of the 9.2 docs:
>
> http://www.postgresql.org/docs/9.2/interactive/functions-datetime.html#FUNCTIONS-DATETIME-TABLE
>
> There is an entry for date_trunc(text, timestamp) but no entry for date_trunc(text, interval). The full docs for date_trunc:
>
> http://www.postgresql.org/docs/9.2/interactive/functions-datetime.html#FUNCTIONS-DATETIME-TRUNC
>
> do mention both the timestamp and interval forms of date_trunc but that's easy to miss if you're just scanning the function lists.
Thanks for the report. The attached patch has been applied and will
appear in PG 9.4. Sorry for the delay.
--
Bruce Momjian <[email protected]> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
Attachments:
[text/x-diff] date_trunc.diff (1.0K, 2-date_trunc.diff)
download | inline diff:
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
new file mode 100644
index 53021c2..e79c479
*** a/doc/src/sgml/func.sgml
--- b/doc/src/sgml/func.sgml
*************** SELECT SUBSTRING('XY1234Z', 'Y*?([0-9]{1
*** 6570,6575 ****
--- 6570,6589 ----
<row>
<entry>
<indexterm>
+ <primary>date_trunc</primary>
+ </indexterm>
+ <literal><function>date_trunc(<type>text</type>, <type>interval</type>)</function></literal>
+ </entry>
+ <entry><type>interval</type></entry>
+ <entry>Truncate to specified precision; see also <xref linkend="functions-datetime-trunc">
+ </entry>
+ <entry><literal>date_trunc('hour', interval '2 days 3 hours 40 minutes')</literal></entry>
+ <entry><literal>2 days 03:00:00</literal></entry>
+ </row>
+
+ <row>
+ <entry>
+ <indexterm>
<primary>extract</primary>
</indexterm>
<literal><function>extract</function>(<parameter>field</parameter> from
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2014-01-23 03:27 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-06-07 18:32 Missing date_trunc docs Eric Howe <[email protected]>
2014-01-23 03:27 ` Bruce Momjian <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox