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.

Oracle LazyDBA home page