select convert(varchar(20),getdate())

How can u convert the Date to String?

Question Posted / deepak rohilla

Answer Posted / deepak rohilla

Is This Answer Correct ?

5 Yes

9 No

Please Help Members By Posting Answers For Below Questions

What are sql server procedures?

979

How to get nth highest salary from employee table.

1163

What is Federation and Federation Member?

What are trace flags?

1031

How to generate create table script on an existing table in ms sql server?

1141

How to write an inner join with the where clause in ms sql server?

1091

How you can get the list of largest tables in a database?

1014

Define indexes?

1042

What is the simplest way to create a new database in ms sql server?

1010

Why do we partition data?

1028

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

2071

What are the differences between stored procedure and view in sql server?

1246

What is isolation levels?

1029

Difference between Sql server reporting services and Crystal reports?

168

What can be used instead of trigger?

1156