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

What is a result set object returned by odbc_exec()?

1079

What is 4nf in normalization form?

1063

What do mean by xml datatype?

1176

What is sub-query in sql server? Explain its properties.

1134

What is self join in sql server joins?

1119

What is isolation levels?

1085

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

1166

What is an indexing strategy?

1072

What is partition in sql server?

1097

What is difference between views and tables?

1078

What is the use of commit?

1063

What are the differences between char and varchar in ms sql server?

1125

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1153

Can you explain full-text query in sql server?

1059

Explain what are various ways to enhance the ssrs report?

1098