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(at)sermonaudio(dot)com]
> Sent: Thursday, June 10, 2004 10:38 AM
> To: pgsql-odbc(at)postgresql(dot)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
>