在C#中是这么些的:
sqlcommand comm = new sqlcommand("查询语句",new sqlconnection(ConnectionString));
comm.connection,open();
sqldatareader r = comm.execreader();
datetime dt = r.getdatetime(序号);
string str = dt.toshortdatetime();
sqlcommand comm = new sqlcommand("查询语句",new sqlconnection(ConnectionString));
comm.connection,open();
sqldatareader r = comm.execreader();
datetime dt = r.getdatetime(序号);
string str = dt.toshortdatetime();
sqlcommand comm = new sqlcommand("查询语句",new sqlconnection(ConnectionString));
comm.connection,open();
sqldatareader r = comm.execreader();
datetime dt = r.getdatetime(序号);
string str = dt.toshortdatetime();
from yourTable
我想应该还有其他更好的办法的吧?所以~~~~~~~~~~~~~关注!
你可以
select convert(varchar,getdate(),120)楼主:
select cast(year(COLNAME) as varchar)+'-'+cast( month(COLNAME) as varchar)+'-'+cast(day(COLNAME) as varchar)