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:

Re: Format function in query
 

What is your input format and what you would like the output to be formatted.

Re: Format function in query
 

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

Re: Format function in query
 

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



CONVERT Function syntax:

Convert (datatype, datetime string, date style)