获取系统时间的方法有服务器读取,和从数据库读取方式。
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");
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();
}
{
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();
}