写sql语句时将时间格式“20110725”转化为格式2012年07月25日
switch (ni.NodeSort)
{
case 0://账户查看
sql = string.Format("select logid,rtrim(logtitle) as logtitle,SUBSTRING(AccDate,1,4)+'年'+SUBSTRING(AccDate,5,2)+'月'+SUBSTRING(AccDate,7,2)+'日' as AccDate,accamount,rtrim(logmemo) as logmemo from LOGACCOUNT where accidin = {0}" +
" union "+
" select logid,rtrim(logtitle) as logtitle,SUBSTRING(AccDate,1,4)+'年'+SUBSTRING(AccDate,5,2)+'月'+SUBSTRING(AccDate,7,2)+'日' as AccDate, -accamount as accamount,rtrim(logmemo) as logmemo from LOGACCOUNT where accidout = {0} ", ni.Id);
break;
case 1://分类查看
sql = string.Format("select logid,rtrim(logtitle) as logtitle,SUBSTRING(AccDate,1,4)+'年'+SUBSTRING(AccDate,5,2)+'月'+SUBSTRING(AccDate,7,2)+'日' as AccDate,accamount,rtrim(logmemo) as logmemo from LOGACCOUNT where SortId = {0}", ni.Id);
break;
}
转载于:https://blog.51cto.com/2938638/941865