Received: from smtp5.mindspring.com (smtp5.mindspring.com [207.69.200.82]) by hub.org (8.9.2/8.9.1) with ESMTP id JAA94693 for ; Wed, 31 Mar 1999 09:31:37 -0500 (EST) (envelope-from clark.evans@manhattanproject.com) Received: from manhattanproject.com (pool-207-205-160-150.nwrk.grid.net [207.205.160.150]) by smtp5.mindspring.com (8.8.5/8.8.5) with ESMTP id JAA29755; Wed, 31 Mar 1999 09:31:25 -0500 (EST) Sender: clark@mindspring.com Message-ID: <370230D5.DA694942@manhattanproject.com> Date: Wed, 31 Mar 1999 14:27:33 +0000 From: Clark Evans X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.0.36 i686) X-Accept-Language: en MIME-Version: 1.0 To: chairudin@prima.net.id CC: pgsql-sql@postgreSQL.org Subject: Re: [SQL] TO_CHAR or TO_DATE References: <37020847.8DBA2C2E@prima.net.id> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Chairudin Sentosa wrote: > How to do it the right way to insert only month and year? You don't, it is necessary to have a day as well. Use the first of the month, and ignore the day in your program. Thus, insert into table values ( '1-MAR-1999' ); Alternatively, you could create your own type and work out all the semantics necessary to only manage months. This sounds interesting actually, only I would do 'week' rather than month. Clark