Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1F3wrx16745 for ; Wed, 14 Feb 2001 22:58:53 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f1F3wi900746 for ; Wed, 14 Feb 2001 22:58:44 -0500 (EST) To: pgsql-docs@postgresql.org Subject: Undocumented datetime functions Date: Wed, 14 Feb 2001 22:58:43 -0500 Message-ID: <743.982209523@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200102/92 X-Sequence-Number: 347 The following date/time related functions are not documented in the obvious place for them, namely http://www.postgresql.org/devel-corner/docs/postgres/functions-datetime.htm now() CURRENT_DATE CURRENT_TIME CURRENT_TIME(n) CURRENT_TIMESTAMP CURRENT_TIMESTAMP(n) EXTRACT(part FROM datetime) --- ANSIfied version of date_part BTW, it seems that date_part accepts rather more options than are documented on this page, as well. regards, tom lane