sql server获取时间段
--当天开始时间
SELECT dateadd(ms,0,DATEADD(dd, DATEDIFF(dd,0,getdate()), 0))
--当天结束时间
SELECT dateadd(ms,-3,DATEADD(dd, DATEDIFF(dd,-1,getdate()), 0))
--当月开始时间
SELECT DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)
--当月结束时间
SELECT dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,getdate())+1, 0))
--查询时间段内数据
select * from dable where case(字段 as datetime) between '2017-3-26' and '2017-3-31'
--asp.net可后台直接格式化时间
DateTime d1 = DateTime.Parse(times);
var c = d1.ToString("yyyy-MM-dd HH:mm:ss");
Oracle获取时间段(关键词to_date)
select * from SELLER_SETTING where UPDATE_DATETIME between to_date('2012-05-01 00:00:00','yyyy-mm-dd hh24:mi:ss') and to_date('2012-05-31 00:00:00','yyyy-mm-dd hh24:mi:ss')
或者另一种写法
select * from SELLER_SETTING where UPDATE_DATETIME>=to_date('2012-05-01 00:00:00','yyyy-mm-dd hh24:mi:ss') and UPDATE_DATETIME<=to_date('2012-05-31 00:00:00','yyyy-mm-dd hh24:mi:ss')