asp.net(c#) sql 字段datetime类型,怎么用insert into语句只插入时间从文本框获取的时间
来源:百度知道 编辑:UC知道 时间:2024/06/07 01:24:01
就是去掉自动增加的1900-1-1
SQL命令中DateTime格式大全
Code in C# :
DateTime MyDate = DateTime.Now;
sSQL = "Insert Into Article (Title,CreatedDate) Values (\'New Title\',\'" + MyDate.Format( "g", null ) + "\')";
格式字符参考表:
Format character
Description
Default return format
d
Short date pattern
MM/dd/yyyy
D
Long date pattern
dddd, MMMM dd, yyyy
f
Full (long date + short time)
dddd, MMMM dd, yyyy HH:mm
F
Full date time pattern (long date + long time)
dddd, MMMM dd, yyyy HH:mm:ss
g
General (short date + short time)
MM/dd/yyyy HH:mm
G
General (short date + long time)
MM/dd/yyyy HH:mm:ss
m,M
Month day pattern
MMMM dd
r,R
RFC1123 pattern
ddd, dd MMM yyyy HH\':\'mm\':\'ss\'GMT\'
s
Sortable da