pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Karel Zak <zakkr@zf.jcu.cz>
To: Thomas Good <tomg@sqlclinic.net>
Cc: Postgres SQL <pgsql-sql@postgresql.org>
Subject: Re: Formatting current_time output
Date: Thu, 3 Oct 2002 17:28:01 +0200
Message-ID: <20021003172801.A31167@zf.jcu.cz> (raw)
In-Reply-To: <Pine.LNX.4.33.0210031041060.11566-100000@q8.nrnet.org>
References: <Pine.LNX.4.33.0210031041060.11566-100000@q8.nrnet.org>

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

view thread (6+ messages)  latest in thread

Message-ID: <20021003172801.A31167@zf.jcu.cz>
Permalink:  ../20021003172801.A31167@zf.jcu.cz/
Also on:    postgresql.org/message-id/20021003172801.A31167@zf.jcu.cz

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: zakkr@zf.jcu.cz, tomg@sqlclinic.net
  Subject: Re: Formatting current_time output
  In-Reply-To: <20021003172801.A31167@zf.jcu.cz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox