begin-select to_char(date,'mmddyyyy') &date_mmddyyyy from table end-select Dominick Logiudice wrote: > 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