34,838
社区成员




CREATE TABLE #T
(
create_time NVARCHAR(255)
)
INSERT INTO #T VALUES('24/6/2017 10:16:36')
INSERT INTO #T VALUES('10/7/2018 16:42:42')
INSERT INTO #T VALUES('30/10/2019 00:21:55')
INSERT INTO #T VALUES('1/12/2020 00:05:08')
SELECT *,CONVERT(DATETIME,create_time,103) FROM #T
DROP TABLE #T