Re: Help with casting timestamp column

Check out the EXTRACT and date_part functions. See the PostgreSQL User's
Guide for more information.

-- 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
>