如何将datetime拆分为date?
我如何转换
19-jan-12 11:12:12 PM to 19-jan-12
我将日期时间存储在SqlServer数据库中
它以"19-jan-12 11:12:12 PM"格式存储
现在我想获取日期为12年1月19日的行
并绑定该数据，以便如何从数据库中检查
请迅速提供帮助
thnx
i store datetime in SqlServer Database
it stored as "19-jan-12 11:12:12 PM" format
now i want to get row whose date is 19-jan-12
and bind that data so how can i check from database
please help quickly
thnx
你好，
请参考
http://msdn.microsoft.com/en-us/library/az4se3k1.aspx
另请参阅
http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx
hello,
please refer
http://msdn.microsoft.com/en-us/library/az4se3k1.aspx
refer this also
http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx
TextBox1.Text = DateTime.Now.ToString("dd-MM-yy");
您可以使用
you can use
dateToDisplay.ToShortDateString()
注意:ToShortDateString方法返回的字符串对区域性敏感.它反映了当前区域性的DateTimeFormatInfo对象定义的模式.例如，对于美国文化，标准的短日期模式为"M/d/yyyy"；对于de-DE文化，它是"dd.MM.yyyy"；对于ja-JP文化，它是"yyyy/M/d".还可以对特定计算机上的特定格式字符串进行自定义，以使其不同于标准的短日期格式字符串.
参考: http://msdn.microsoft.com/en-us/library/system. datetime.toshortdatestring.aspx [ ^ ]
NOTE : The string returned by the ToShortDateString method is culture-sensitive. It reflects the pattern defined by the current culture''s DateTimeFormatInfo object. For example, for the en-US culture, the standard short date pattern is "M/d/yyyy"; for the de-DE culture, it is "dd.MM.yyyy"; for the ja-JP culture, it is "yyyy/M/d". The specific format string on a particular computer can also be customized so that it differs from the standard short date format string.
ref : http://msdn.microsoft.com/en-us/library/system.datetime.toshortdatestring.aspx[^]