On Fri, Jul 10, 2009 at 3:31 PM, Wills, Steve <[email protected]> wrote:

>   The cool thing is that (CTXT(JDATE())) used in this way still sorts
> exactly like INTEGER and DATE values.
>
>
>

Ahh, but be warned: this will lead to serious problems when we roll over to
5-digit years. the year 9999 will sort *after* the year 10000. It will be
known as the Y10K problem.

Bill

Reply via email to