X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id DE9379DC881 for ; Mon, 13 Feb 2006 17:12:00 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 20454-02 for ; Mon, 13 Feb 2006 17:12:01 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by postgresql.org (Postfix) with ESMTP id 927B89DC887 for ; Mon, 13 Feb 2006 17:11:58 -0400 (AST) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id k1DLBiHY055756 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Mon, 13 Feb 2006 14:11:47 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.4/8.13.4) with ESMTP id k1DLBhHZ073919; Mon, 13 Feb 2006 14:11:43 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.4/8.13.4/Submit) id k1DLBh0c073918; Mon, 13 Feb 2006 14:11:43 -0700 (MST) (envelope-from mfuhr) Date: Mon, 13 Feb 2006 14:11:43 -0700 From: Michael Fuhr To: Jim Fu Cc: pgsql-admin@postgresql.org Subject: Re: to_date Message-ID: <20060213211142.GA73849@winnie.fuhr.org> References: <2BE5FA188E433143A09D9881BB923D32096F30@hou1x.Logixcom.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <2BE5FA188E433143A09D9881BB923D32096F30@hou1x.Logixcom.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.121 required=5 tests=[AWL=0.121] X-Spam-Score: 0.121 X-Spam-Level: X-Archive-Number: 200602/169 X-Sequence-Number: 20590 On Mon, Feb 13, 2006 at 02:44:45PM -0600, Jim Fu wrote: > I am new here, just wondering if PostgreSQL has a similar function > TO_DATE ('02/12/2006','mm/dd/yyyy')? Yes: test=> select to_date('02/12/2006','mm/dd/yyyy'); to_date ------------ 2006-02-12 (1 row) The documentation describes the available functions; here are some useful links: http://www.postgresql.org/docs/ http://www.postgresql.org/docs/8.1/interactive/functions.html Your client interface might have a way to list or search for functions. For example, in psql you can use the \df command: test=> \df to_date List of functions Schema | Name | Result data type | Argument data types ------------+---------+------------------+--------------------- pg_catalog | to_date | date | text, text (1 row) Are you having trouble with to_date or are you just curious? If you're having trouble then please show what you're doing, the exact error message or unexpected output, the version of PostgreSQL, and the operating system name and version. -- Michael Fuhr