Re: Help with casting timestamp column

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/