From: | Janet Borschowa <borschow(at)roguewave(dot)com> |
---|---|
To: | 'Chris Hoover' <revoohc(at)sermonaudio(dot)com>, pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Help with casting timestamp column |
Date: | 2004-06-10 18:02:31 |
Message-ID: | D486606E7AD20947BDB7E56862E04C39041CC4@cvo1.cvo.roguewave.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Janet Borschowa | 2004-06-10 18:03:10 | Re: Help with casting timestamp column |
Previous Message | Chris Gamache | 2004-06-10 18:00:29 | Re: Help with casting timestamp column |