Horton

Re: Formatting current_time output

Karel Zak <zakkr@zf.jcu.cz>

View thread View on postgr.es
From: Karel Zak <zakkr@zf.jcu.cz>
To: Thomas Good <tomg@sqlclinic.net>
Cc: Postgres SQL <pgsql-sql@postgresql.org>
Date: 2002-10-03T15:28:01Z
Lists: pgsql-sql 
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  <zakkr@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/
 
 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz