Re: Interesting Behavior using REVERSE()

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Wed, 07 Apr 2004 15:39:26 GMT
Message-ID: <KgVcc.90638$JO3.44927@attbi_s04>

"Alan" <alan_at_erols.com> wrote in message news:c516b7$2mme4v$1_at_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
>
>
>

Sort of. It relies on a specific nls date setting so it won't work for some nls date settings (or different results) Jim Received on Wed Apr 07 2004 - 10:39:26 CDT