Received: from snfc21.pbi.net (mta5.snfc21.pbi.net [206.13.28.241]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6U4IBf57757 for ; Mon, 30 Jul 2001 00:18:11 -0400 (EDT) (envelope-from GonzoRock@Excite.com) Received: from charlie2 ([64.170.56.6]) by mta5.snfc21.pbi.net (iPlanet Messaging Server 5.1 (built May 7 2001)) with SMTP id <0GH900543QM88C@mta5.snfc21.pbi.net> for pgsql-sql@postgresql.org; Sun, 29 Jul 2001 21:18:08 -0700 (PDT) Date: Sun, 29 Jul 2001 21:19:11 -0700 From: Gonzo Rock Subject: Date Time Functions - ANSI SQL ? X-Sender: sbames@postoffice.pacbell.net (Unverified) To: pgsql-sql@postgresql.org Message-id: <3.0.5.32.20010729211911.00c8cec0@postoffice.pacbell.net> MIME-version: 1.0 X-Mailer: QUALCOMM Windows Eudora Pro Version 3.0.5 (32) Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT X-Archive-Number: 200107/377 X-Sequence-Number: 4191 Curious to know... Are all the date time functions described in the pgSQL docs are ANSI-SQL or pgSQL extensions? For Example in the Docs: ------------------------ 4.7.1. EXTRACT, date_part EXTRACT (field FROM source) The extract function retrieves sub-fields from date/time values, such as year or hour. source is a value expression that evaluates to type timestamp or interval. (Expressions of type date or time will be cast to timestamp and can therefore be used as well.) field is an identifier (not a string!) that selects what field to extract from the source value. The extract function returns values of type double precision. The following are valid values: day The day (of the month) field (1 - 31) SELECT EXTRACT(DAY FROM TIMESTAMP '2001-02-16 20:38:40'); Result: 16 Thanks all,