Received: from smtp-4.ig.com.br (smtp-4.ig.com.br [200.225.157.63]) by hub.org (8.10.1/8.10.1) with SMTP id e8T27Bp59335 for ; Thu, 28 Sep 2000 22:07:12 -0400 (EDT) Message-Id: <200009290207.e8T27Bp59335@hub.org> Received: (qmail 21522 invoked from network); 29 Sep 2000 02:06:58 -0000 Received: from unknown (HELO MYHOSTNAME) (200.217.201.73) by smtp-4.ig.com.br with SMTP; 29 Sep 2000 02:06:58 -0000 From: "Edipo E. F. Melo" To: "pgsql-sql@postgresql.org" Date: Thu, 28 Sep 2000 23:05:03 -0300 (ADT) Reply-To: "Edipo E. F. Melo" X-Mailer: (Demonstration) PMMail 2.00.1500 for OS/2 Warp 4.00 In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Subject: Date problem X-Archive-Number: 200009/231 Hi all, Hi all, Before all, a little (off-topic) comment: >It's been my experience that Win32 ODBC does not drop >connections until the database client is closed (e.g. MS >Access is shut down). "There is some things that only Micro$oft can do for you..." Ok. Let's work. I posted a mail before explaining a strange cituation if my Postgresql: when I use date_part() function to split day, month and year of a date type column, it returns one day before. In other words, '2000-01-01' returns day: 31, month:12, year: 1999. I'm using OS/2 with Fix Pack 12, Postgresql 7.0.2. Can any one explain this? []'s Edipo Elder F. de Melo