使用带有dd-mm-yyyy格式的datepicker插入日期 [英] insert date using datepicker with dd-mm-yyyy format

问题描述

hi


想要一个简单的编码

==>使用dd-MM-yyyy格式的存储过程在sql server数据库中插入日期



表如

========================= =========

table：= birthdate

----------



dob_id    数字（8,0）

dob        日期或日期时间



=============================== ===

dob_id     dob

------       ---

1         11-06-1990

2         14-02-1989



值必须以此格式插入。通过传递datepicker



谢谢

hi
want a simple coding for
==>insert date in sql server database using stored procedure with dd-MM-yyyy format

table like
==================================
table := birthdate
----------

dob_id      numeric(8,0)
dob          date or datetime

==================================
dob_id      dob
------        ---
1          11-06-1990
2          14-02-1989

values have to insert in this format. by passing datepicker

thank you

推荐答案

不要将日期存储为字符串;总是使用DATE或DATETIME - 以后你会省去很多麻烦。

Do not store dates as strings; always use DATE or DATETIME -- you'll save yourself a lot of trouble later.

对于时间格式化，使用 System.DateTime.ToString amd System.DateTime.ToLongString 带有一些参数的方法允许您使用当前线程文化，明确定义文化（以接口<$ c $的形式） c> System.IFormatProvider 由类 System.Globalization.CultureInfo 实现，或者通过指定确切的格式，标准或自定义。请参阅：

http://msdn.microsoft.com /en-us/library/system.datetime%28v=vs.110%29.aspx [ ^ ]，

http://msdn.microsoft.com/en-us/library/system.global ization.cultureinfo％28v = vs.110％29.aspx [ ^ ]，

http://msdn.microsoft.com/en-us/library/system.iformatprovider%28v=vs.110%29.aspx [ ^ ]。



格式说明符请参阅：

http://msdn.microsoft.com/en-us/library/az4se3k1%28v=vs.110%29.aspx [ ^ ]，

http：/ /msdn.microsoft.com/en-us/library/8kb3ddd4%28v=vs.110 ％29.aspx [ ^ ]。

-SA

For time formatting, use System.DateTime.ToString amd System.DateTime.ToLongString methods with some parameters allowing you to use current thread culture, explicitly defined culture (in the form of the reference to the interface System.IFormatProvider implemented by class System.Globalization.CultureInfo, or by specifying exact format, standard or custom. Please see:
http://msdn.microsoft.com/en-us/library/system.datetime%28v=vs.110%29.aspx[^],
http://msdn.microsoft.com/en-us/library/system.globalization.cultureinfo%28v=vs.110%29.aspx[^],
http://msdn.microsoft.com/en-us/library/system.iformatprovider%28v=vs.110%29.aspx[^].

For format specifiers, please see:
http://msdn.microsoft.com/en-us/library/az4se3k1%28v=vs.110%29.aspx[^],
http://msdn.microsoft.com/en-us/library/8kb3ddd4%28v=vs.110%29.aspx[^].

—SA

这篇关于使用带有dd-mm-yyyy格式的datepicker插入日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！