How can u convert the Date to String?

Answer Posted / sivakumar

Select convert(varchar(20),getdate()) As Date

Is This Answer Correct ?    5 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a mutating table error and how can you get around it?

703


How many databases Microsoft SQL server provides?

772


How to create view in stored procedure sql server?

683


What is an expression in ms sql server?

720


How to declare a cursor with "declare ... Cursor" in ms sql server?

735






Tell me what is fill factor?

708


How do I find the sql server version?

702


What part does database design plays a role in performance of an sql server-based application?

713


What are the different types of triggers in SQL SERVER?

717


Which autogrowth database setting is good?

785


What is the purpose of update statistics and scope_identity() function?

814


Which rendering formats are affected by the pagesize properties?

122


Explain optimistic and pessimistic concurrency?

720


What do you understand by a view?

720


What is bcp? When does it use?

668