Postgres Pro
Downloads
Home   >   mailing lists

Re: Formatting current_time output - Mailing list pgsql-sql

From Karel Zak
Subject Re: Formatting current_time output
Date
Msg-id 20021003172801.A31167@zf.jcu.cz
Whole thread Raw
In response to Formatting current_time output  (Thomas Good <tomg@sqlclinic.net>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Thomas Good
Date:
Subject: Re: Formatting current_time output
Next
From: Achilleus Mantzios
Date:
Subject: Re: epoch to date