\n <\/td>\n | --<\/span> Obtención de un objeto DATETIME desde una cadena de texto<\/span><\/td>\n <\/tr>\n \n <\/td>\n | \n<\/td>\n <\/tr>\n | \n <\/td>\n | SELECT<\/span> CAST('<\/span>20200101'<\/span><\/span> AS<\/span> DATETIME) AS<\/span> fecha<\/td>\n <\/tr>\n \n <\/td>\n | \n<\/td>\n <\/tr>\n | \n <\/td>\n | --<\/span> resultado <\/span><\/td>\n <\/tr>\n \n <\/td>\n | --<\/span> 01/01/2020 0:00:00<\/span><\/td>\n <\/tr>\n \n <\/td>\n | \n<\/td>\n <\/tr>\n | \n <\/td>\n | \n<\/td>\n <\/tr>\n | \n <\/td>\n | --<\/span> Resta de un mes a la fecha obtenida desde una cadena de texto<\/span><\/td>\n <\/tr>\n \n <\/td>\n | \n<\/td>\n <\/tr>\n | \n <\/td>\n | SELECT<\/span> dateadd(month, -<\/span>1<\/span>, CAST('<\/span>20200101'<\/span><\/span> AS<\/span> DATETIME)) AS<\/span> fecha<\/td>\n <\/tr>\n \n <\/td>\n | \n<\/td>\n <\/tr>\n | \n <\/td>\n | --<\/span> resultado<\/span><\/td>\n <\/tr>\n \n <\/td>\n | --<\/span> 01/12/2019 0:00:00<\/span><\/td>\n <\/tr>\n \n <\/td>\n | <\/td>\n <\/tr>\n | \n <\/td>\n | <\/td>\n <\/tr>\n | \n <\/td>\n | --<\/span> Formatea una fecha a un patrón de fecha definido por el usuario<\/span><\/td>\n <\/tr>\n \n <\/td>\n | <\/td>\n <\/tr>\n | \n <\/td>\n | SELECT<\/span> format( dateadd(month, -<\/span>1<\/span>, CAST('<\/span>20200101'<\/span><\/span> AS<\/span> DATETIME)), '<\/span>dd-MM-yyyy HH:mm:ss'<\/span><\/span>) AS<\/span> fecha<\/td>\n <\/tr>\n \n <\/td>\n | \n<\/td>\n <\/tr>\n | \n <\/td>\n | --<\/span> resultado<\/span><\/td>\n <\/tr>\n \n <\/td>\n | --<\/span> 01/12/2019 0:00:00<\/span><\/td>\n <\/tr>\n <\/table>\n<\/div>\n\n\n <\/div>\n\n <\/div>\n<\/div>\n\n <\/div>\n | | | | | | | | | | | |