datetime format

my sql server have this datetime format ( 1980-10-10 )
how could i change it to 10.10.1980 format
thanksRead:
(1) SET DATEFORMAT
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_set-set_052s.asp
(2) CONVERT
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp
in Books Online.
--
Rohtash Kapoor
http://www.sqlmantra.com
"Esref Durna" <991763@.students.emu.edu.tr> wrote in message
news:%23xovr3hAEHA.580@.TK2MSFTNGP11.phx.gbl...
> my sql server have this datetime format ( 1980-10-10 )
> how could i change it to 10.10.1980 format
> thanks
>