select to_char(my_timestamp,'MM/DD/YYYY HH') from t;
returns a string representation of the timestamp...
HTH,
CG
--- Chris Hoover <revoohc@sermonaudio.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/