order by
decode('AST',1,'EST',2,'CST',3,'MST',4,'PST',5,'HST',6 ,7)

-----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


--
This message has been scanned for viruses and dangerous content by
MailScanner, and is believed to be clean.

Douglas County, Oregon
www.co.douglas.or.us


Oracle LazyDBA home page