Question

SQL中datetime类型不能用substring函数该用哪个代替?

SQL中datetime类型不能用substring函数该用哪个代替? 现有一个字段值是2010-1-12，用什么语句可以改成2010-01-12？

Answer 1

select convert(varchar(10),datetime,20) as datetime from table

Answer 2

DateTime nn = new DateTime();
nn =DateTime.Parse("2010-1-12");
Response.Write(nn.ToString("yyyy-MM-dd"));

Answer 3

string str="2010-1-12"
str=str.Replace("-1","-01")