sqlserver中格式化时间：yyyyMMddHHmmss->yyyy-MM-dd HH:mm:ss

sqlserver将yyyyMMddHHmmss转换成yyyy-MM-dd HH:mm:ss

-- bigint 格式化时间 yyyy-MM-dd HH:mm:ssselect FORMAT(20161207160310,'####-##-## ##:##:##') time-- varchar 格式化时间  yyyy-MM-dd HH:mm:ssselect FORMAT(cast('20161207160310' as bigint),'####-##-## ##:##:##') timeselect cast(FORMAT(cast('20161207160310' as bigint),'####-##-## ##:##:##') as datetime) timeselect cast(FORMAT(cast('20161207160310' as bigint),'####-##-## ##:##:##') as datetime2(0)) time

来自王老师~~~