Received: from pacific.centre.edu (pacific.centre.edu [208.219.120.2]) by hub.org (8.9.1/8.9.1) with ESMTP id KAA25715 for ; Tue, 19 Jan 1999 10:36:29 -0500 (EST) (envelope-from shane@centre.edu) Received: from mercury.centre.edu ([208.219.120.22]) by pacific.centre.edu (Netscape Messaging Server 3.56) with ESMTP id 154 for ; Tue, 19 Jan 1999 10:46:20 -0500 Received: from MERCURY/SpoolDir by mercury.centre.edu (Mercury 1.43); 19 Jan 99 10:33:01 gmt-5 Received: from SpoolDir by MERCURY (Mercury 1.43); 19 Jan 99 10:32:51 gmt-5 Received: from centre.edu (208.219.120.13) by mercury.centre.edu (Mercury 1.43) with ESMTP; 19 Jan 99 10:32:49 gmt-5 Message-ID: <36A4A5A1.36CB7282@centre.edu> Date: Tue, 19 Jan 1999 10:32:49 -0500 From: Shane Wilson X-Mailer: Mozilla 4.5 [en] (Win95; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Time format Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Is there a way to convert the time data type from a 24 hour clock to a 12 hour clock time with am and pm? Example 17:12:00 to 5:12:00 PM Shane