Thursday, 5 September 2013

sql server 2008 Replace,convert datetime

SELECT replace(convert(varchar, getdate(), 106), ' ', '/') as dd   --convert and make date format

No comments:

Post a Comment

How to highlight selected text in notepad++

  –> To highlight a block of code in Notepad++, please do the following steps step-1  :- Select the required text. step-2  :- Right click...