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

Benefits of Stored Procedures?

647


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1146


Can we check locks in database? If so, how can we do this lock check?

610


What is spid in sql server profiler?

620


What is SQL Azure Federations?

106






Is ssrs support other database except ms sql server?

98


Explain Capacity planning to create a database? and how to monitor it?

3851


What is model database in sql server?

682


How do I save a stored procedure in sql server?

582


What is update locks?

583


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

1190


How can you stop stored procedures from recompiling?

564


Can we use trigger new in before insert?

601


When we should use @@error?

626


Explain raiserror in sql server?

660