Format function in query

Hi All!
I am new to sql server 2005
I want to use format function in sql query
Format(dtfld,'dd-mmm-yyyy').
How to use it ?:nonod:
Also for numbers, format(no1,"0.00") :crazy:

 

My database contains dt as "datetime" type.
I want it in format as dd-mmm-yyyy

 

MS SQL Server 2005 provides CONVERT function to change or convert the DateTime formats.



CONVERT Function syntax:

Convert (datatype, datetime string, date style)