文本框中的系统日期 [英] System date in textbox
本文介绍了文本框中的系统日期的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
朋友,
在SQL查询中插入命令以从文本框中插入日期,我需要查询日期格式,
hi friends,
wats the insert statement in sql query to insert a date from a textbox, i need query along with date formats,
推荐答案
sql的默认格式为MM/DD/YYYY.因此,最好使用默认格式构造一个sql查询.像MySql db一样,我们没有任何日期格式.
样品查询:
SQL Server/MS访问数据库:
插入tbl_tableName(Name,Address,DateOfBirth)VALUES(``John'',``Trichy'',``11/31/2011'');
MySql数据库:
Hi,
The default format of sql is MM/DD/YYYY. So it is good to construct a sql query with the default format. Like MySql db we don''t have any Date Format.
Sample Query:
SQL Server/Ms Access Database:
INSERT INTO tbl_tableName (Name,Address,DateOfBirth) VALUES(''John'',''Trichy'',''11/31/2011'');
MySql Database:
public class MySQLDateFormat
{
public const string MONTH_DATE_YEAR = "%m/%d/%Y";
public const string MONTH_DATE_YEAR_SEC = "%m/%d/%Y %H:%i:%s";
public const string DATE_MONTH_YEAR = "%d/%m/%Y";
public const string DATE_MONTH_YEAR_SEC = "%d/%m/%Y %H:%i:%s";
public const string YEAR_MONTH_DATE = "%Y/%m/%d";
public const string YEAR_MONTH_DATE_SEC = "%Y/%m/%d %H:%i:%s";
public const string HOUR_MINUTE_SECONDS = "%H:%i:%s";
public const string HOUR_MINUTE_SECONDS_AM_PM = "%H:%i:%s";
}
查询:
插入tbl_tableName(Name,Address,DateOfBirth)VALUES(``John'',``Trichy'',DATE_FORMAT(``11/31/2011'',''%m/%d/%Y'');
注意:
您可以像我上面给出的那样设置一个单独的类,并在日期格式的地方进行修饰.
Query:
INSERT INTO tbl_tableName (Name,Address,DateOfBirth) VALUES(''John'',''Trichy'',DATE_FORMAT(''11/31/2011'',''%m/%d/%Y'');
Note:
You can have a separate class like I have given above and concadinate in the date format place.
检查一下:
日期格式的文本框
check this out:
textbox with date format
textbox1.text = DateTime.Now.ToString("yyyyMMddmmss");
插入查询
insert query
insert into (value1)
values(textbox1.text);
希望对您有帮助,
如果有帮助,别忘了投票
谢谢
hope it helps,
don''t forget to vote if it helps you
thanks
这篇关于文本框中的系统日期的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文