Content-Length: 259866 | pFad | http://github.com/postgrespro/postgres/commit/74f4881d7cc9c69cb0e0b236f06d1ebf9859a737

F6 Document why you can't use date_trunc("week") on intervals. · postgrespro/postgres@74f4881 · GitHub
Skip to content

Commit 74f4881

Browse files
committed
Document why you can't use date_trunc("week") on intervals.
1 parent 1d9a6ae commit 74f4881

File tree

1 file changed

+5
-0
lines changed

1 file changed

+5
-0
lines changed

doc/src/sgml/func.sgml

Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -7050,6 +7050,11 @@ date_trunc('<replaceable>field</replaceable>', <replaceable>source</replaceable>
70507050
</simplelist>
70517051
</para>
70527052

7053+
<para>
7054+
<literal>week</literal> is not supported for <type>interval</>
7055+
values because months usually have fractional weeks.
7056+
</para>
7057+
70537058
<para>
70547059
Examples:
70557060
<screen>

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres/commit/74f4881d7cc9c69cb0e0b236f06d1ebf9859a737

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy