See also the function to_char.
-- Janet
> -----Original Message-----
> From: Chris Hoover [mailto:revoohc@sermonaudio.com]
> Sent: Thursday, June 10, 2004 10:38 AM
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] Help with casting timestamp column
>
>
> I need a bit of help. I have a table full of database stats that are
> all timestamped using the now() timestamp. However, I need
> to pull some
> consolidated reports that are based upon hourly activiy. Does anyone
> know of a way to get a timestamp column to return as mm/dd/yyyy hh?
>
> Thanks for any help,
>
> chris
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
>