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 factless fact table? : sql server analysis services, ssas

565


What extended events?

553


Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

527


What are the advantages of paper records?

559


Why use identity in sql server?

568






Tell me can we use custom code in ssrs?

601


What are sub reports and how to create them?

99


What are the different type of replication in sql server?

540


Is the order of columns in the set clause important in ms sql server?

521


How to get the definition of a trigger back?

551


How to find the service pack installed? : sql server database administration

554


Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

502


What is the difference RDBMS and Graph Database?

631


What is the impact on other user sessions when creating indexes?

544


What does REVERT do in SQL Server 2005?

568