Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re: Time sorting please help

by malloc (Pilgrim)
on Jul 18, 2001 at 01:30 UTC ( [id://97464]=note: print w/replies, xml ) Need Help??


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.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://97464]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others scrutinizing the Monastery: (1)
As of 2024-04-25 02:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found