X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 76E84D1B520 for ; Wed, 1 Oct 2003 07:21:25 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 65217-08 for ; Wed, 1 Oct 2003 04:20:40 -0300 (ADT) Received: from main.gmane.org (main.gmane.org [80.91.224.249]) by svr1.postgresql.org (Postfix) with ESMTP id AA4ABD1B4F6 for ; Wed, 1 Oct 2003 04:20:37 -0300 (ADT) Received: from root by main.gmane.org with local (Exim 3.35 #1 (Debian)) id 1A4bHp-0000eu-00 for ; Wed, 01 Oct 2003 09:20:37 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-docs@postgresql.org Received: from sea.gmane.org ([80.91.224.252]) by main.gmane.org with esmtp (Exim 3.35 #1 (Debian)) id 1A4bEM-0000c3-00 for ; Wed, 01 Oct 2003 09:17:02 +0200 Received: from news by sea.gmane.org with local (Exim 3.35 #1 (Debian)) id 1A4bEM-00076u-00 for ; Wed, 01 Oct 2003 09:17:02 +0200 From: Troels Arvin Subject: LOCALTIMESTAMP should be mentioned in datatype-datetime.html Date: Wed, 01 Oct 2003 09:17:05 +0200 Lines: 15 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@sea.gmane.org User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/1 X-Sequence-Number: 2021 Hello, About section 8.5.1.5. ("Special Values"): I suggest adding LOCALTIMESTAMP and LOCALTIME to the first paragraph. Maybe it should be phrased as: The following SQL-compatible functions can be used to obtain current datetime-related values: CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, LOCALTIME and LOCALTIMESTAMP. (See Section 9.8.4.) -- Greetings from Troels Arvin, Copenhagen, Denmark