select * from BEDS t WHERE to_char(CREATE_TIME,'yyyy') LIKE '2018'
select to_char(to_date(CREATE_TIME,'yyyy-mm-dd'),'day') as day from BEDS t
select * from BEDS t where Trim(to_char(to_date(CREATE_TIME,'yyyy-mm-dd'),'day')) = 'sunday' --查询所有周日的数据 记得加 Trim·
select CREATE_TIME,to_char(CREATE_TIME,'DDD') from BEDS t --查询这是一年中的第多少天