Re: Formatting current_time output

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Thomas Good <tomg(at)sqlclinic(dot)net>
Cc: Postgres SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Formatting current_time output
Date: 2002-10-03 15:28:01
Message-ID: 20021003172801.A31167@zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/

C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Achilleus Mantzios 2002-10-03 15:28:35 Re: Formatting current_time output
Previous Message Charles H. Woloszynski 2002-10-03 15:22:48 Re: Formatting current_time output