Select convert(varchar(20),getdate()) As Date

How can u convert the Date to String?

Question Posted / sivakumar

Answer Posted / sivakumar

Is This Answer Correct ?

5 Yes

5 No

Please Help Members By Posting Answers For Below Questions

How do I find the size of a sql server database?

908

How to create user messages with print statements in ms sql server?

971

Distinguish between nested subquery and correlated subquery?

1021

What is the difference between count () and rowcount ()?

1001

How to disable triggers using "disable trigger"?

1033

Does index speed up select statements?

1001

What is self contained multi valued query?

985

How can we call UDF(User Define Function) using C# code in ASP.net ?

6862

Equi join and non equi join is possible with sql server?

997

What is an execution plan? When would you use it?

957

How to insert data with null values?

1006

How connect excel to sql server?

971

What are data regions?

134

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1111

What is sql server query analyzer?

1005