Re: Need help Datefield Retrieval like this mmddyyyy

["Singh, Rajvirendra ( NYSDS )" <RajvirendraSingh@EXCHANGE.ML.COM>]

Begin-select
to_char(start_date,'mmddyyyy')  &start_date

>From XXXXXXXXX
End-select

or

if you are using 4.x then change SQR_DB_DATE_FORMAT
or use ALTER-LOCALE

        -----Original Message-----
        From:   Dominick Logiudice [SMTP:dlogiudice@PINE.VPCC.SUNYSB.EDU]
        Sent:   Wednesday, September 23, 1998 12:07 PM
        To:     Multiple recipients of list SQR-USERS
        Subject:        Need help Datefield Retrieval like this mmddyyyy

        Say I have a field called start date on a oracle db
        I want to retrieve in like this mmddyyyy

        How would I do this with sqr

        Thanks