Received: from berith.cyberdeck.net (berith.cyberdeck.net [194.79.164.5]) by hub.org (8.9.3/8.9.3) with ESMTP id DAA10886 for ; Fri, 21 Apr 2000 03:46:47 -0400 (EDT) (envelope-from benoit@cyberdeck.net) Received: from cyberdeck.net (asmodeus.cyberdeck.com [194.79.164.226]) by berith.cyberdeck.net (8.9.3/Cyberdeck - Mail) with ESMTP id JAA27817 for ; Fri, 21 Apr 2000 09:43:03 +0200 Message-ID: <39000669.7F87401@cyberdeck.net> Date: Fri, 21 Apr 2000 09:42:33 +0200 From: Benoit Brodard Organization: Cyberdeck X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.14 i586) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Date_part & cast. Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200004/240 Hi, We use PostgreSQL 6.5.3 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3, and we get the following results with date_part : db=> select date_part( 'dow', date '20000421' ); date_part --------- 5 (1 row) db=> select date_part( 'dow', date ( '20000421' ) ); date_part --------- 6 (1 row) Is this correct ? If yes, I could not find any explanation for the second result which also differ from "select date_part( 'dow', date (20000421) );" Thanks for any help, -Benoit Brodard.