Try this (again)

SELECT llOpenCases, llTimeZone,
decode(llTimeZone,'AST',1,'EST',2,'CST',3,'MST',4,'PST',5,'HST',6,7)sort_order
FROM LL_HOUSEHOLD
ORDER BY sort_order

Sean Painter




-----Original Message-----
From: Randall TJ
[mailto:oracledba-ezmlmshield-x97686042.[Email address protected]
Sent: Friday, February 25, 2005 3: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