How can u convert the Date to String?
Answer Posted / deepak rohilla
select convert(varchar(20),getdate())
Is This Answer Correct ? | 5 Yes | 9 No |
Post New Answer View All Answers
What is the use of stored procedure?
How to recreate an existing index in ms sql server?
What is the difference between Clustered and Non-Clustered Index?
What is policy management?
Explain indexed views?
What is the use of builtinadministrators group in sql server? : sql server security
What are page splits?
what does the automatic recovery do? : Sql server administration
How do I edit a stored procedure in sql server?
How many joins in sql server?
Why I can not enter 0.001 second in date and time literals in ms sql server?
What do you do in data exploration
Where sql server user names and passwords are stored in sql server? : sql server database administration
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?