[shukla]

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 ?
Also for numbers, format(no1,"0.00")

[shabbir]

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

[shukla]

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

[naimish]

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



CONVERT Function syntax:

Convert (datatype, datetime string, date style)