在v.s 2010中保存英文编号 [英] Saving english number in v.s 2010

问题描述

当我想在sqlexpress中保存日期时，我的日期编号是persion，因为它显示了她

1395/09/01但我希望每次都像1395/09/01。

因为我的keyboarb可以用persion语言设置。



我尝试过：

当我想在sqlexpress中保存日期时，我的日期编号是persion，因为它显示了她的
 1395/09/01但我想要像1395/09 / 01每次。 
因为我的keyboarb可以设置为persion语言。

解决方案

SQL与日期的方式没有任何关系显示 - 这是一个演示功能，您的软件负责从SQL获取日期并为当前用户正确格式化：因此，SQL中的日期与格式无关，它们符合ISO标准。

看看其中一些： sql server convert date to persian - Google搜索 [ ^ ]

when i want to save date in the sqlexpress my date number are persion as it shown her
۱۳۹۵/۰۹/۰۱ but i want be like 1395/09/01 every time.
becuse may my keyboarb be set on persion language.

What I have tried:

when i want to save date in the sqlexpress my date number are persion as it shown her
۱۳۹۵/۰۹/۰۱ but i want be like 1395/09/01 every time.
becuse may my keyboarb be set on persion language.

解决方案

SQL doesn't have anything to do with how dates are displayed - that is a presentation function, and your software is responsible for fetching the date from SQL and formatting it appropriately for the current user: as a result, dates in SQL are format agnostic, they conform to the ISO standard.
Have a look at some of these: sql server convert date to persian - Google Search[^]

这篇关于在v.s 2010中保存英文编号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！