'2012-06-25 14:44'----假设这个是获取的当前时间,请问下面两个时间如何得到,
'2012-06-25 12:00'
'2012-06-25 14:00'
C#:
DateTime dt = DateTime.Now;
DateTime dt1 = dt.Date.AddHours(12);
DateTime dt2 = dt.Date.AddHours(dt.Hour);
SQL:
declare @dt datetime,@dt0 datetime,@dt1 datetime,@dt2 datetime
set @dt=GETDATE()
set @dt0=CONVERT(datetime,str(datepart(year,@dt))+'-'+str(datepart(month,@dt))+'-'+str(datepart(day,@dt)))
set @dt1=DATEADD(hour,12,@dt0)
set @dt2=DATEADD(hour,datepart(hour,@dt),@dt0)
select @dt,@dt1,@dt2
string str1 = DateTime.Now.ToString("yyyy-MM-dd 12:00");
string str2 = DateTime.Now.ToString("yyyy-MM-dd 14:00");
文章转载于 http://q.163.com/luohzhihou/poster/61112495/ 转载请保留 连接谢谢