sql server时间操作迷茫中...

[gxboy]

由于对mssql接触较少。昨天遇到这样一个问题

sql = "insert into tables(a,b) values('" & users & "',#" & Now() & "#)"

这样好象无法在mssql中执行。最后以这种方式解决：

sql = "insert into tables(a,b) values('" & users & "','" & Now() & "')"

B表当然设的是datatime类型，为什么会以字符串型式处理？？？？

[aquariusBoy]

datetime类型在插入的时候都是字符串的形式插入的，只是有格式的规定，比如1981-06-03

[saucer]

your approach has two problems:
1. if b is always set to Now, you should do it in the database, set its default value to getdate()
2. you don't know the format like you are saying
3. it is subject to sql injection attack

you should use a parameterized query, for example

sql = "insert into tables(a,b) values(@users,@dates)"
SqlCommand cmd = new SqlCommand(sql,conn);
cmd.Parameters.Add("@users","whatever");
cmd.Parameters.Add("@dates", DateTime.Now);
conn.Open();
cmd.ExecuteNonQuery();

[blackcatiii]

or you may write sql like below:
"insert into tables(a,b) values(@users,getDate())";
getDate() is a function used by sql server to get the current date and time of the datebase server.

[batisituta]

用getdate()函数取时间。

[gxboy]

thank !