Postgres Pro
Downloads
Home   >   mailing lists

Re: Mailing - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Mailing
Date
Msg-id 20041006150030.GC15406@wolff.to
Whole thread Raw
In response to Re: Mailing  (Kevin Barnard <kevin.barnard@gmail.com>)
List pgsql-general
Tree view 
On Tue, Oct 05, 2004 at 10:00:29 -0500,
  Kevin Barnard <kevin.barnard@gmail.com> wrote:
> SELECT trim(leading '0'  from to_char(now(), 'HH:MM AM'))
>
> I think is what you really want.  This gets rid of the nasty leasing 0.

Won't that be a problem for times between 0000 and 0059?

pgsql-general by date:

Previous
From: Mark Gibson
Date:
Subject: Cache lookup failed for relation, when trying to DROP TABLE.
Next
From: Ying Lu
Date:
Subject: Commands to browse current connections and processes