Excel Function : CONVERT

Download now!

Excel Function : CONVERT




Converts a number from one measurement system to another

Microsoft Excel Reference Page


Syntax and Description of the CONVERT Excel Function

in sql server I have a table in sql server with varchar datatype column. I wanted to convert the column from mm/dd/yyyy to yyyy-mm-dd I have used below syntax. select convert(datetime,'2/2/2016',110) It works fine. My column is not in datetime datatype. How can I use convert(datetime,column_name,110) to convert the column in sql server? A: You can

About CONVERT Excel Function

The CONVERT function converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers.