Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id ACAF9475A09 for ; Thu, 3 Oct 2002 11:28:18 -0400 (EDT) Received: from ara.zf.jcu.cz (ara.zf.jcu.cz [160.217.161.4]) by postgresql.org (Postfix) with ESMTP id 6EA8C4758F1 for ; Thu, 3 Oct 2002 11:28:17 -0400 (EDT) Received: from ara.zf.jcu.cz (LOCALHOST [127.0.0.1]) by ara.zf.jcu.cz (8.12.1/8.12.1/Debian -5) with ESMTP id g93FS1hb031247; Thu, 3 Oct 2002 17:28:02 +0200 Received: (from zakkr@localhost) by ara.zf.jcu.cz (8.12.1/8.12.1/Debian -5) id g93FS1fF031246; Thu, 3 Oct 2002 17:28:01 +0200 Date: Thu, 3 Oct 2002 17:28:01 +0200 From: Karel Zak To: Thomas Good Cc: Postgres SQL Subject: Re: Formatting current_time output Message-ID: <20021003172801.A31167@zf.jcu.cz> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: ; from tomg@sqlclinic.net on Thu, Oct 03, 2002 at 10:46:19AM -0400 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/41 X-Sequence-Number: 9759 On Thu, Oct 03, 2002 at 10:46:19AM -0400, Thomas Good wrote: > > SELECT TO_CHAR(SYSDATE,'HH:MI AM') FROM DUAL; -- Oracle > SELECT TIME_FORMAT(current_time,'%l:%i %p'); -- MySQL SELECT TO_CHAR(now(),'HH:MI AM'); -- PostgreSQL :-) -- Karel Zak http://home.zf.jcu.cz/~zakkr/ C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz