Horton

Formatting current_time output

Thomas Good <tomg@sqlclinic.net>

View thread View on postgr.es
From: Thomas Good <tomg@sqlclinic.net>
To: Postgres SQL <pgsql-sql@postgreSQL.org>
Date: 2002-10-03T14:46:19Z
Lists: pgsql-sql 
Hi.

Anyone have any tips on how I can approximate the following:

SELECT TO_CHAR(SYSDATE,'HH:MI AM') FROM DUAL; -- Oracle
SELECT TIME_FORMAT(current_time,'%l:%i %p');  -- MySQL

Returned:   10:58 AM

I've found lpad(current_time,5); which gets me 1/3 of the way.
Is there a function I haven't found?

TIA
-----------------------------------------------------------------------
Thomas Good                                  e-mail: tomg@sqlclinic.net
Programmer/Analyst                           phone:   (+1) 718.818.5528
Residential Services                         fax:     (+1) 718.818.5056
Behavioral Health Services, SVCMC-NY         mobile:  (+1) 917.282.7359
--                                                                   --
SQL Clinic - An Open Source Clinical Record           www.sqlclinic.net
------------------------------------------------------------------------