Sounds like you need a function (to spit out a predefined numeric value for
each timezone) in the order by clause. Or maybe there is actually a way to
order by timezone...

-HL

-----Original Message-----
From: Randall TJ
[mailto:oracledba-ezmlmshield-x97686042.[Email address protected]
Sent: Friday, February 25, 2005 12:49 PM
To: LazyDBA Discussion
Subject: ORDER BY


I am getting a result set that includes time zone, and I would like to sort
a result set by a specified order of time zones.

SELECT llOpenCases, llTimeZone
FROM LL_HOUSEHOLD
ORDER BY llTimeZone

Gives me AST, CST, EST, .....

Is it possible to define in the ORDER BY clause, the time zones going from
AST -> HST? My desired order is: AST, EST, CST, MST, PST, HST

Thank you!!

T.j.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page