Received: from ns1.prima.net.id ([202.57.0.8]) by hub.org (8.9.2/8.9.1) with ESMTP id XAA36406 for ; Tue, 30 Mar 1999 23:34:11 -0500 (EST) (envelope-from chairudin@prima.net.id) Received: from prima.net.id (mail.prima.net.id [202.57.0.8]) by ns1.prima.net.id (8.8.4/8.7.2) with ESMTP id SAA16929 for ; Wed, 31 Mar 1999 18:34:31 +0700 (GMT) Sender: root@ns1.prima.net.id Message-ID: <37020847.8DBA2C2E@prima.net.id> Date: Wed, 31 Mar 1999 04:34:31 -0700 From: Chairudin Sentosa Reply-To: chairudin@prima.net.id Organization: PT. Khasanah Timur Indonesia X-Mailer: Mozilla 4.5 [en] (X11; I; SunOS 5.5.1 sun4u) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgreSQL.org Subject: TO_CHAR or TO_DATE References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, Is the any similar function to 'to_char' and to_date' from Oracle in Postgresql? I have a problem insert only month-year. create table blah (id varchar(10), month date, week int4, amount float8 ); insert into blah (id, month, week, amount) values ('1','MAR-1999',1,,3000); I got error message : Bad date external representation MAR-1999 How to do it the right way to insert only month and year? Regards, Chai