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

Is null vs coalesce?

510


How to restore performance issues and how to check?

1527


What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

559


What is the difference between stored procedure and user defined functions?

631


How to set database to be read_only in ms sql server?

554






How do I debug a stored procedure in sql server?

541


What is the process of normalising?

592


What is normalization according to you and explain its different levels?

527


What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

654


What is normalization? Describe its different types.

588


How to get all stored procedures in sql server?

510


What are the parts of a function?

523


What are views used for?

621


What is enhanced database mirroring in sql server 2008?

519


What is table valued function and scalar valued functions?

497