Would YYYYMMDD meet your criteria?
On Thu, 30 Jul 2009 12:33:35 -0400, Ya Huang <ya.huang@AMYLIN.COM> wrote:
>Obviously sorting a date var as numeric is different from a date9.
>formatted character, since '03JAN2009' is ordered after '03APR2009'.
>But '03JAN2009'DT should have the same order as '01032009'. For time
>var, a time5. formatted string will not have the same order as the
>underline numeric var, since time5. is not zero padded.
>I wonder what kind of formatted date, time or datetime var have
>the same order as the underline numeric var.