change the date format in a table sql query code example Example: sql convert date to string yyyy-mm-dd select CONVERT(char(10), GetDate(),126) /* 2020-12-23 */