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

Determine when an index is appropriate?

567


What is the difference between TRUNCATE and DROP?

633


What do you mean by the term 'normalization'?

674


Mention the command used to rename the database.

536


Explain rdbms?

608






What is the difference between ddl,dml and dcl commands?

614


Do you know data definition language, data control language and data manipulation language?

634


Is sql server is free?

552


Explain about merge replications?

599


How can we get count of the number of records in a table?

549


How can you find out which stored procedures are recompiling?

520


What is a benefit of using an after insert trigger over using a before insert trigger?

523


Explain about unique identifier data type in sql server?

519


In which sql server version report builder introduced?

105


Explain what are the authentication modes in sql server?

504