may i know have this statement?

set date format 'dd/mm/yyyy'
select * from tablename

i have a data in my table and the date format in my table is mm/dd/yyyy, so when i run this sql statemet in query analyzer is it possible to list out the date format is 'dd/mm/yyyy'?