Re: Mailing

From: Todd P Marek <affe23(at)somahq(dot)com>
To: Kevin Barnard <kevin(dot)barnard(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Mailing
Date: 2004-10-05 15:06:51
Message-ID: 2FB02D52-16E0-11D9-8F90-000393823F90@somahq.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Oct 5, 2004, at 10:00 AM, Kevin Barnard 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.

I wasn't even paying attention to the seconds. I was in fact talking
about the leading 0.

Thanks to everyone and apologies for my oversight of the seconds clause.

Todd Marek

In response to

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

Responses

  • Re: Mailing at 2004-10-05 15:09:56 from Kevin Barnard

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Barnard 2004-10-05 15:09:56 Re: Mailing
Previous Message Csaba Nagy 2004-10-05 15:05:33 Re: Mailing