Received: from negral.com (negro.negral.com [195.70.32.252]) by hub.org (8.9.3/8.9.3) with ESMTP id IAA87366 for ; Tue, 29 Feb 2000 08:27:31 -0500 (EST) (envelope-from forgacs@negral.com) Received: from negral.hu (fw.apollo-imaging.com [195.26.208.226]) by negral.com (8.9.3/8.9.3/Debian/GNU) with ESMTP id OAA02969 for ; Tue, 29 Feb 2000 14:21:23 +0100 Message-ID: <38BBC9D2.DCB94658@negral.hu> Date: Tue, 29 Feb 2000 14:29:54 +0100 From: Forgacs Tamas Reply-To: forgacs@negral.com Organization: NeGRAL Co. X-Mailer: Mozilla 4.7 [en] (WinNT; I) X-Accept-Language: en,pdf MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: DATE formatting problem again Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello, I am searching after the date formatting solution, but didn't found a correct one. So example ORACLE has - to_char function to make any kind of date format from a date type: to_char(now,'yyyy.mm.dd') - to_date to makes a date type from any kind of string: to_date ('1999.11.23','yyyy.mm.dd') I don't believe that this very easy thing is not made in PostgreSQL. It can be made as function also, but I have no time to learn PL/pgSQL languague... By the way: how can You use wildcards for date type (with to_char is easy, but without??) Regards: FT !!!PLEASE MAIL THE ANSWER TO ME ALSO: efte@negral.com