How can u convert the Date to String?
Answer Posted / prasad
select convert(varchar,columnname,101) from tablename
Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
How do I find the query plan in sql server?
How to view existing indexes on an given table using sys.indexes?
How to count duplicated values in a column in ms sql server?
What is the recovery model? List the types of recovery model available in sql server?
What is index in an assignment?
What is sql collation?
How to return the top 5 rows from a select query in ms sql server?
How to create a view on an existing table in ms sql server?
How to make a remote connection in a database?
What is the difference between writing data to mirrored drives versus raid5 drives
Difference between report and query parameter.
Can we use pragma autonomous_transaction in trigger?
How to convert numeric values to integers in ms sql server?
What is the difference between web edition and business edition?
What is right outer join in sql server joins?