Dan:

You don't have to use stored procedures. It can be imbedded into a select statement:

select convert(char(10), somedatefield, 101) from sometable

Charlie