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:03:10 |
Message-ID: | D486606E7AD20947BDB7E56862E04C39041CC5@cvo1.cvo.roguewave.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
See also the function to_char.
-- 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 | Peter Eisentraut | 2004-06-10 18:08:56 | Re: [Fwd: [SECURITY] [DSA 516-1] New odbc-postgresql packages fix denial of service] |
Previous Message | Janet Borschowa | 2004-06-10 18:02:31 | Re: Help with casting timestamp column |