Dominick,
If I'm not mistaken,
select tochar(start_date, 'MMDDYYYY')
will give you what you want.
Chuck Chauvin
-----Original Message-----
From: Dominick Logiudice [SMTP:dlogiudice@PINE.VPCC.SUNYSB.EDU]
Sent: Wednesday, September 23, 1998 11:07 AM
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