Its just simple. Try the following query and it will give you the result.
SELECT REPLACE(convert(varchar(11), getdate(), 109),’ ‘,’/')
Subscribe to:
Post Comments (Atom)
ASP.Net, MS SQL, PHP, MYSql, .Net 3.5, .Net 4.0, .Net 2.0, BizTalk Server 2006 R2, XMl, JavaScript, AJAX
No comments:
Post a Comment