diff options
| author | Bruce Momjian <bruce@momjian.us> | 2012-08-15 16:03:58 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2012-08-15 16:03:58 -0400 |
| commit | 74f4881d7cc9c69cb0e0b236f06d1ebf9859a737 (patch) | |
| tree | c01c9d3704340980311e4bffd2206d6c6fef24d4 | |
| parent | 1d9a6ae8555da4a7de0046c61264748602ff6086 (diff) | |
| download | postgresql-74f4881d7cc9c69cb0e0b236f06d1ebf9859a737.tar.gz postgresql-74f4881d7cc9c69cb0e0b236f06d1ebf9859a737.zip | |
Document why you can't use date_trunc("week") on intervals.
| -rw-r--r-- | doc/src/sgml/func.sgml | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index d5ad4718b15..5d0c71a8b9f 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -7051,6 +7051,11 @@ date_trunc('<replaceable>field</replaceable>', <replaceable>source</replaceable> </para> <para> + <literal>week</literal> is not supported for <type>interval</> + values because months usually have fractional weeks. + </para> + + <para> Examples: <screen> SELECT date_trunc('hour', TIMESTAMP '2001-02-16 20:38:40'); |