select convert(varchar,columnname,101) from tablename

How can u convert the Date to String?

Question Posted / prasad

Answer Posted / prasad

Is This Answer Correct ?

11 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Are resultset updatable?

953

What is difference between commit and rollback when used in transactions?

959

How do I run a trace in sql server?

983

What do you mean by stored techniques? How would we use it?

1034

What is difference between sql and sql server?

1005

How to execute the cursor queries with "open" statements?

1180

How do you delete a trigger?

981

Can you explain what is the use of custom fields in report?

1062

What is the maximum size of column in sql server?

893

What are triggers in ms sql server?

1162

Why I can not enter 0.001 second in date and time literals in ms sql server?

1065

What do you know about system database? : SQL Server Architecture

985

Why do we use trigger?

974

How do you trace the traffic hitting a sql server?

1141

Why do you need a sql server?

1111