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

Explain filestream storage of sql server 2008?

694


What is the sql profiler?

688


What are the advantages of using stored procedures?

687


Write query to return all rows sql?

792


How do I start sql server agent automatically?

690






What is sql server agent and what are the two modes of authentication in sql server?

738


Is it possible to have clustered index on separate drive from original table location?

688


What is cursor in ms sql server?

767


How many types of objects are there?

685


What is optimistic concurrency?

748


Where actually sql azure database is hosted?

157


How to connect sql server management studio express to sql server 2005 express?

749


Other than truncate statement, which other command can by-pass the trigger on the tables?

810


How do I view a trc file?

684


What is service broker?

766