Re: Mailing

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Kevin Barnard <kevin(dot)barnard(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, Todd P Marek <affe23(at)somahq(dot)com>
Subject: Re: Mailing
Date: 2004-10-06 15:00:30
Message-ID: 20041006150030.GC15406@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Oct 05, 2004 at 10:00:29 -0500,
Kevin Barnard <kevin(dot)barnard(at)gmail(dot)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?

In response to

  • Re: Mailing at 2004-10-05 15:00:29 from Kevin Barnard

Browse pgsql-general by date

  From Date Subject
Next Message Mike Nolan 2004-10-06 15:06:00 Re: two digit years in inserts
Previous Message Ying Lu 2004-10-06 14:59:31 Commands to browse current connections and processes