Received: from ns1.prima.net.id ([202.57.0.8]) by hub.org (8.9.3/8.9.3) with ESMTP id GAA00863 for ; Mon, 4 Oct 1999 06:18:54 -0400 (EDT) (envelope-from chai@prima.net.id) Received: from prima.net.id (chai@[202.57.0.54]) by ns1.prima.net.id (8.8.4/8.7.2) with ESMTP id KAA06416 for ; Mon, 4 Oct 1999 10:22:45 +0700 (GMT) Sender: chai@ns1.prima.net.id Message-ID: <37F87EDE.D69CE07F@prima.net.id> Date: Mon, 04 Oct 1999 17:18:06 +0700 From: Chairudin Sentosa Harjo Reply-To: chai@prima.net.id X-Mailer: Mozilla 4.61 [en] (X11; I; Linux 2.2.10 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: month and 2000 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Dear All, Two questions: One --- How to select a date in order to get this form: 30-OCT-1999 I tried : select date(sub_date) from tbl_date; 30-10-1999 What switch do I need to get 'OCT'? Two --- Why this happen? tbs=> select date ('now'); date ---------- 01-01-2000 (1 row) I am sure the time on my computer is correct, the year is 1999, the month is October and the date is 4th. Why the select gives 1st January 2000??? SuSE 6.2, Postgresql 6.5.2, Pentium III. Regards, Chai