如何控制 MS-SQL Server 返回日期时间值的格式?

2021-09-10 00:00:00 tsql sql-server

具体来说,我希望以纯 (ISO) 格式获取日期格式:

Specifically, I wish to get the date format in a pure (ISO) format:

YYYY-MM-DD HH:mm:ss

YYYY-MM-DD HH:mm:ss

我正在寻找 SET 命令或我可以使用的东西.

I'm looking for a SET command or something that I can use.

我不想依赖服务器的文化设置.

I do not wish to rely on the culture setting of the server.

注意:我对返回日期而不是输入日期的字符串格式感兴趣.

Note: I'm interested in the string format in which dates are returned, not entered.

推荐答案

要更改默认格式,您需要添加一种新语言 (sp_addlanguage),设置它的日期格式,然后为其设置默认语言.可以在这篇旧的技术网文章上找到更多详细信息.

To change the default format you need to add a new language (sp_addlanguage), set it's date format, then set the default language to it. More details can be found on this old technet article.

如果您不想这样做,那么您可以使用 设置日期格式.

If you don't want to do that, then you can change it "per connection" using SET DATEFORMAT.

如果你不想这样做,那么你可以使用 CONVERT 将其转换为每个查询中的相关格式字符串.

And if you don't want to do that, then you can use CONVERT to convert it to the relevent format string in each query.

相关文章