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


Please Help Members By Posting Answers For Below Questions

What is the use of stored procedure?

591


How to recreate an existing index in ms sql server?

623


What is the difference between Clustered and Non-Clustered Index?

685


What is policy management?

665


Explain indexed views?

648






What is the use of builtinadministrators group in sql server? : sql server security

628


What are page splits?

670


what does the automatic recovery do? : Sql server administration

639


How do I edit a stored procedure in sql server?

601


How many joins in sql server?

603


Why I can not enter 0.001 second in date and time literals in ms sql server?

631


What do you do in data exploration

636


Where sql server user names and passwords are stored in sql server? : sql server database administration

652


What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

691


What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

634