SQL Server 将字符串转换为日期时间
这不是问如何在 MSSQL 中将任意字符串转换为日期时间，例如 this问题.
This is not asking how to convert an arbitrary string to datetime in MSSQL such as this question.
我可以控制字符串格式，但我想知道使用日期字符串更新日期时间字段的 MSSQL 语法是什么.
I can control the string format but I want to know what the MSSQL syntax is for updating a datetime field using a date string.
推荐答案
比如你可以使用
update tablename set datetimefield='19980223 14:23:05'
update tablename set datetimefield='02/23/1998 14:23:05'
update tablename set datetimefield='1998-12-23 14:23:05'
update tablename set datetimefield='23 February 1998 14:23:05'
update tablename set datetimefield='1998-02-23T14:23:05'
您需要注意日/月顺序，因为如果没有首先指定年份，这将取决于语言.如果您先指定年份，则没有问题；日期顺序将始终为年-月-日.
You need to be careful of day/month order since this will be language dependent when the year is not specified first. If you specify the year first then there is no problem; date order will always be year-month-day.
相关文章