From: | Chris Gamache <cgg007(at)yahoo(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:00:29 |
Message-ID: | 20040610180029.13181.qmail@web13806.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
select to_char(my_timestamp,'MM/DD/YYYY HH') from t;
returns a string representation of the timestamp...
HTH,
CG
--- Chris Hoover <revoohc(at)sermonaudio(dot)com> wrote:
> 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
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Janet Borschowa | 2004-06-10 18:02:31 | Re: Help with casting timestamp column |
Previous Message | Chris Hoover | 2004-06-10 17:37:52 | Help with casting timestamp column |