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