获取系统时间

获取系统时间的方法有服务器读取，和从数据库读取方式。

Oracle获取年月日
select to_char(sysdate,'YYYY-MM-DD') from dual
Oracle获取星期几
select to_char(sysdate,'day') from dual

C#
    DateTime.Now.ToLongDateString();

    返回 日,一,......
    string dayOfWeek = DateTime.Now.ToString("ddd", (new CultureInfo("zh-cn")));

String sysDate = getDate("select to_char(sysdate,'YYYY-MM-DD') from dual");

private   string  getDate( string  sqlStr)
     ... {

        OracleConnection conn = new OracleConnection("Data Source=INFOPLAT;User ID=infomanager;Password=admin;");

        OracleCommand cmd = new OracleCommand();

        cmd.Connection = conn;

        cmd.CommandText = sqlStr;

        cmd.CommandType = CommandType.Text;
        // 创建数据集
        DataSet ds = new DataSet();
        try
        ...{
            conn.Open();

            OracleDataReader read = cmd.ExecuteReader();
            while (read.Read())
            ...{
                return read.GetString(0);
            }

        }
        catch (Exception ex)
        ...{
            Response.Write("数据库错误，错误原因：" + ex.Message);
            Response.End();
        }
        finally
        ...{
            // 释放占有资源
            conn.Close();
        }
        return DateTime.Now.ToLongDateString();
    }