Received: from Kitten.mcs.com (Kitten.mcs.com [192.160.127.90]) by hub.org (8.8.8/8.7.5) with ESMTP id QAA04239 for ; Tue, 25 Aug 1998 16:52:46 -0400 (EDT) Received: from Venus.mcs.net (les@Venus.mcs.net [192.160.127.92]) by Kitten.mcs.com (8.8.7/8.8.2) with ESMTP id PAA01228 for ; Tue, 25 Aug 1998 15:52:40 -0500 (CDT) Received: (from les@localhost) by Venus.mcs.net (8.8.7/8.8.2) id PAA07004 for pgsql-sql@postgreSQL.org; Tue, 25 Aug 1998 15:52:40 -0500 (CDT) From: Leslie Mikesell Message-Id: <199808252052.PAA07004@Venus.mcs.net> Subject: Date vs. Datetime boundaries To: pgsql-sql@postgreSQL.org Date: Tue, 25 Aug 1998 15:52:39 -0500 (CDT) X-Mailer: ELM [version 2.4 PL24] Content-Type: text Are the 'extract' values off on the boundary values of date data types? (With pgsql 6.3.2): create table dtest ( adate date, adt datetime ); insert into dtest values ('01-01-1998', '01-01-1998') ; insert into dtest values ('01-31-1998', '01-31-1998') ; insert into dtest values ('02-01-1998', '02-01-1998') ; insert into dtest values ('02-02-1998', '02-02-1998') ; select extract (month from adate), extract (month from adt), * from dtest ; date_part|date_part| adate|adt ---------+---------+----------+---------------------------- 12| 1|01-01-1998|Thu Jan 01 00:00:00 1998 CST 1| 1|01-31-1998|Sat Jan 31 00:00:00 1998 CST 1| 2|02-01-1998|Sun Feb 01 00:00:00 1998 CST 2| 2|02-02-1998|Mon Feb 02 00:00:00 1998 CST (4 rows) --- select * from dtest where extract(month from adate) = 12; adate|adt ----------+---------------------------- 01-01-1998|Thu Jan 01 00:00:00 1998 CST (1 row) ----- Les Mikesell les@mcs.com