Home > mailing lists

Re: Mailing - Mailing list pgsql-general

From	Kevin Barnard
Subject	Re: Mailing
Date	October 5, 2004 19:00:39
Msg-id	b068057c04100508006246d593@mail.gmail.com Whole thread Raw
In response to	Re: Mailing (Csaba Nagy <nagy@ecircle-ag.com>)
Responses	Re: Mailing (Todd P Marek <affe23@somahq.com>) Re: Mailing (Csaba Nagy <nagy@ecircle-ag.com>) Re: Mailing (Bruno Wolff III <bruno@wolff.to>)
List	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.

From: Robby Russell
Date: 05 October 2004, 18:58:45
Subject: Re: Mailing

From: Todd P Marek
Date: 05 October 2004, 19:07:05
Subject: Re: Mailing