What you need is the to_char() function. The
documentation for this function can be found here:
http://www.postgresql.org/idocs/index.php?functions-formatting.html
Here's an example of how you would use this function.
processdata=> select to_char(now(), 'YYYY-DD-MM
HH:MM:SS PM')
processdata-> ;
to_char
------------------------
2001-04-06 08:06:32 AM
(1 row)
Notice how the format string has PM in it but the time
returned is AM, that spooked me at first, but it seems
to work as one would hope.
Jason
--- Eric Naujock <naujocke@abacusii.com> wrote:
> I am looking for a way to get my time format to
> display in the format of hh:mm AM/PM instead to the
> default 24 hour time format. Does anybody have any
> suggestions for how to do this?
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
> (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/