Sunday, February 5, 2012

Selecting date in the format of dd-MMM-yyyy


SELECT replace(convert(varchar(11),RevisedON,106),' ','-') AS [DD-Mon-YYYY]
from tblTest


for selecting date in the format of 11-Nov-2010

No comments:

Post a Comment

Comments

Search

Custom Search
Protected by Copyscape Plagiarism Software