oracle 将时间 0:00:00除去的两种方法

   public DataTable CopyTable(DataTable oldTable)
        {
            DataTable newTable = oldTable.Clone();
            newTable.Clear();
            for (int i = 0; i < newTable.Columns.Count; i++)
            {
                if (newTable.Columns[i].DataType == typeof(DateTime))
                {
                    newTable.Columns[i].DataType = typeof(string);
                }
            }

            for (int i = 0; i < oldTable.Rows.Count; i++)
            {
                DataRow dr = newTable.NewRow();

                for (int j = 0; j < oldTable.Columns.Count; j++)
                {
                    if (oldTable.Columns[j].DataType == typeof(DateTime))
                    {
                        string str = ((DateTime)oldTable.Rows[i][j]).ToString("yyyy-MM-dd");
                        dr[j] = str;
                    }
                    else
                    {
                        dr[j] = oldTable.Rows[i][j];
                    }
                }

                newTable.Rows.Add(dr);
            }
            return newTable;
        }

 

 

方法二

            DataTable tableCol = cChildTable.GetDCountyList(" t.childtableguid='" + strWhere + "' and t.columnssign=1").Tables[0];
            for (int m = 0; m < tableCol.Rows.Count; m++)
            {
                if (tableCol.Rows[m]["columnstype"].ToString().ToUpper().Equals("DATE"))
                {
                    sqlColumns += " to_char(" + tableCol.Rows[m]["COLUMNSNAME"].ToString() + ",'yyyy-MM-DD') as " + tableCol.Rows[m]["columnsdesc"].ToString() + ", ";
                }
                else
                {
                    sqlColumns += tableCol.Rows[m]["COLUMNSNAME"].ToString() + " as " + tableCol.Rows[m]["columnsdesc"].ToString() + ", ";
                }
            }

 

显示1，2，3，4改正（1，3）（2，4）显示方式

        private void NewDataShow(StringBuilder builder)
        {
            builder.Append("  <table width=\"100%\" border=\"0\" cellpadding=\"2\" cellspacing=\"0\" class=\"lis\">");
            for (int m = 0; m < tables.Rows.Count; m++)
            {
                DataRow dr = tables.NewRow();
                for (int j = 0; j < tables.Columns.Count; j = j + 2)
                {
                    try
                    {
                        builder.Append("  <tr>");
                        builder.Append("  <td width=\"25%\" align=\"right\">");
                        builder.Append("" + tables.Columns[j] + "");
                       // builder.Append(" <span>：</sapn></td>");
                        builder.Append(" </td>");
                        builder.Append("  <td width=\"25%\" align=\"left\">");
                        builder.Append("" + tables.Rows[m][j] + "");
                        builder.Append("  </td>");
                        builder.Append("  <td width=\"25%\" align=\"right\">");
                        builder.Append("" + tables.Columns[j + 1] + "");
                       // builder.Append(" <span>：</sapn></td>");
                        builder.Append(" </td>");
                        builder.Append("  <td width=\"25%\" align=\"left\">");
                        builder.Append("" + tables.Rows[m][j + 1] + "");
                        builder.Append("  </td>");
                        builder.Append("  </tr>");
                    }
                    catch
                    {
                        builder.Append("  <td width=\"25%\" align=\"right\">");
                        builder.Append(" </td>");
                    }
                }
            }
            builder.Append("  </table>");
            Literal2.Text = builder.ToString();
        }