| From: | Larry Rosenman <ler(at)lerctr(dot)org> |
|---|---|
| To: | hodges(at)xprt(dot)net |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Time Formatting |
| Date: | 2002-05-10 01:55:32 |
| Message-ID: | 1020995733.327.6.camel@lerlaptop |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Thu, 2002-05-09 at 20:37, hodges(at)xprt(dot)net wrote:
> Is there a builtin function in Postgres to display the
> time as XX:XX am or XX:XX pm?
>
look at the to_char function on
http://www.lerctr.org/postgresql/functions-formatting.html
(this is my copy of the docs).
> Cheers, Tom Hodges
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hodges | 2002-05-10 03:30:17 | Re: Time Formatting |
| Previous Message | hodges | 2002-05-10 01:37:50 | Time Formatting |