SQL Server 2008将日期从dd/mm/yyyy强制为MM/dd/yyyy [英] Sql server 2008 forcing date from dd/MM/yyyy to MM/dd/yyyy
问题描述
我对sql server 2008有一个奇怪的问题.我试图将 dd/MM/yyyy
格式的日期保存到sql server 2008中,但是在插入日期后,它会自动转换为MM/dd/yyyy
.
I have a weird problem with sql server 2008. I am trying to save date with dd/MM/yyyy
format into sql server 2008, But after inserting date it automatically get converted into MM/dd/yyyy
.
注意:我的计算机时钟格式为 dd/MM/yyyy
Note : my computer clock format is dd/MM/yyyy
我的报告查看器日期文本框属性
My report viewer date text box properties
数据库表中的日期在此处输入图片描述
我的C#代码
lbldate.Text = DateTime.Today.ToShortDateString();
lbldate.Text = DateTime.Today.ToShortDateString();
报告日期2017/05/04
date on report 05/04/2017
推荐答案
可以这么说,我不会说这是一个问题".这就是SQL处理日期的方式.您的计算机时钟格式不相关.要更改格式,请在查询中使用CONVERT.例如:
I would not say this is a "problem" so to speak. This is how SQL handles dates. Your computer clock format is not relevant. To change the format, use CONVERT in your queries. Ex:
SELECT CONVERT(varchar, GETDATE(), 103)
Results: 04/05/2017
SELECT CONVERT(varchar, GETDATE(), 101)
Results: 05/04/2017
The codepage arguments are listed here: https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql
根据新更新进行您的C#应该如下所示:
edit per your new update: Your C# should look something like this:
DateTime.Now.ToString("dd/mm/yyyy")
这篇关于SQL Server 2008将日期从dd/mm/yyyy强制为MM/dd/yyyy的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!