Interesting Behavior using REVERSE()

From: Alan <alan_at_erols.com>
Date: Wed, 7 Apr 2004 11:22:21 -0400
Message-ID: <c516b7$2mme4v$1@ID-114862.news.uni-berlin.de>

Seems like a great way to hide dates, if you ever need to...

SQL> SELECT TRUNC(SYSDATE) AS TEST_DATE FROM DUAL; TEST_DATE

---

07-APR-04 SQL> SELECT REVERSE(TRUNC(SYSDATE)) AS TEST_DATE FROM DUAL; TEST_DATE

---

00-DECEMB SQL> SELECT REVERSE(REVERSE(TRUNC(SYSDATE))) AS TEST_DATE FROM DUAL; TEST_DATE

---

07-APR-04 Received on Wed Apr 07 2004 - 10:22:21 CDT