Re: Looking for a way to get my time format.

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/