我有一个表,我想在其中将字符串转换为日期时间并插入.但是,我收到一个转换失败的错误
INSERT INTO CUSTOMERS_PURCHASE([PURCHASE_DATE], [PURCHASE_TIME], [PURCHASE_CITY])
SELECT CAST( '03-January-2023' AS DATETIME2) AS PURCHASE_DATE,
[PURCHASE TIME] AS PURCHASED_TIME, [PURCHASE_CITY] FROM CUSTOMERS_INDIA
错误:从字符串转换日期和/或时间时转换失败.
我能得到一些关于如何解决这个问题的建议/帮助吗?我正在使用Microsoft SQL