Re: Mailing

From: Kevin Barnard <kevin(dot)barnard(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: Todd P Marek <affe23(at)somahq(dot)com>
Subject: Re: Mailing
Date: 2004-10-05 15:00:29
Message-ID: b068057c04100508006246d593@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Csaba Nagy 2004-10-05 15:05:33 Re: Mailing
Previous Message Robby Russell 2004-10-05 14:58:23 Re: Mailing