Question: how to convert dd/mm/yy to yyyy-mm-dd in sql?
Answer: ﻿We can also change the date format by using CONVERT function. Hi BikashBiswal, If the data type of the column is DATE, then the value should be in YYYY-MM-DD format. In SQL 2012 and up check out FORMAT() function in Help if you'd like to return formatted data to the client.