in reply to Need help sorting timestamps

Sir, i am not sure what you are exactly asking, but wouldn't it be simpler to select the date in a format that would be easier to sort? Just specify a date mask when selecting it from Oracle. Something like
select to_char(date_col,'YYYYMMDDHH24MISS') from table;


Should make it much easier! I hope this helps you out,
-malloc

Replies are listed 'Best First'.
Re: Re: Time sorting please help
by swarddb (Novice) on Jul 18, 2001 at 20:53 UTC
    For display purpose (Web Reporting) i then have to reformat it for display. i was hoping to sort the hash in some way rather than changing the format of the data. People get pick about what they are used to seeing.