Have you tried something like this? begin-select to_char(startdate,'mmddyyyy') &start_date from ... where ... 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