Help with casting timestamp column

From: "Chris Hoover" <revoohc(at)sermonaudio(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Help with casting timestamp column
Date: 2004-06-10 17:37:52
Message-ID: 40C89C70.1050006@sermonaudio.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Chris Gamache 2004-06-10 18:00:29 Re: Help with casting timestamp column
Previous Message TANIDA Yutaka 2004-06-10 08:08:39 Re: [Fwd: [SECURITY] [DSA 516-1] New odbc-postgresql packages fix denial of service]