如何在sqlExpress中将日期的mm/dd/yyyy格式转换为dd/mm/yyyy格式 [英] how to convert mm/dd/yyyy format of date into dd/mm/yyyy format in sqlExpress

问题描述

如何在SqlExpress中将日期的mm/dd/yyyy格式转换为dd/mm/yyyy格式?不同之处.应该根据需要在用户界面中对其进行修改.

您确实没有提供足够的信息来提供准确的答案.

如果您的意思是SQLServer实例的日期格式设置为mm/dd/yyyy，并且希望将其设置为dd/mm/yyyy，则 ^ ]可能会有用.

如果您的意思是说您有一个过程/函数接收的mm/dd/yyyy格式的字符串，则此 [ ^ ]会有所帮助.

除此之外，请编辑您的问题，准确地说出您遇到的问题.

How to convert mm/dd/yyyy format of date into dd/mm/yyyy format in SqlExpress?

解决方案

Date format in the database should not make any difference. It should be modified in the UI as per your need.

You really do not give enough information to enable a precise answer.

If you mean that the instance of SQLServer has it''s date format set to mm/dd/yyyy and you want it to be dd/mm/yyyy then this[^] might be useful.

If you mean that you have a procedure/function that receives a string in mm/dd/yyyy format then this[^] will help.

For anything else, please edit your question to say exactly what problem you are having.

这篇关于如何在sqlExpress中将日期的mm/dd/yyyy格式转换为dd/mm/yyyy格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！