is there a way to format$() the data directly in the select statement without looping thru the rs?

e.g.
select field1, format$(field2,"dd mmm yyyy") from table1


thanks,
benj