获取当前时间
DateTime dt = DateTime.Now; //本地时间
从数据库读取timestamp
(1)数据库中为timestamp(0)格式(0表示精确到秒)
(2)直接select得到DateTime格式,例:
query = “SELECT request_time FROM leave_information”
reader.GetDateTime(“request_time”)
DateTime类型转换
(1)string → DateTime
//法一
Convert.ToDateTime(string);
//string格式要求必须是yyyy-MM-dd hh:mm:ss
//法二 指定格式
DateTimeFormatInfo dtFormat = new System.GlobalizationDateTimeFormatInfo();
dtFormat.ShortDatePattern = "yyyy/MM/dd";
DateTime dt = Convert.ToDateTime("2011/05/26", dtFormat);
(2)DateTime → string
DateTime dt = DateTime.Now;
dt.ToString(); //2005-11-5 13:21:25
参考: