| From: | Kevin Barnard <kevin(dot)barnard(at)gmail(dot)com> |
|---|---|
| To: | Todd P Marek <affe23(at)somahq(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Mailing |
| Date: | 2004-10-05 15:09:56 |
| Message-ID: | b068057c0410050809620c9b1c@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Going back to the documents I think Tom's answer of prepending FM is
better then mine. Look at table 9-22 for other options
On Tue, 5 Oct 2004 10:06:51 -0500, Todd P Marek <affe23(at)somahq(dot)com> wrote:
>
>
>
> 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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marek Lewczuk | 2004-10-05 15:22:17 | postgresql 8.0 and tsearch2 install under cygwin |
| Previous Message | Todd P Marek | 2004-10-05 15:06:51 | Re: Mailing |