sql 如何选取某时间段 的数据代码

Question

如何选取2017-07-27到2017-07-28 8:00到18:00的数据 怎么写代码
select*
from 表
where
substr （gmt_resolve,1,10）＞=‘2017-07-27’

and （gmt_resolve,1,10）＜=‘2017-07-28’
如何再将时间点添加上去？

Answer 1

sql 如何选取某时间段 的数据代码

1

select * from " tableName " where DATA_TIME >=<a href="https://www.baidu.com/s?wd=CONVERT&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1d9PynLmhRYuW6knjKBPAN-0ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EPH6zPHDvnjnsPHn4P1fkPHmd" target="_blank" class="baidu-highlight">CONVERT</a>(<a href="https://www.baidu.com/s?wd=VARCHAR&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1d9PynLmhRYuW6knjKBPAN-0ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EPH6zPHDvnjnsPHn4P1fkPHmd" target="_blank" class="baidu-highlight">VARCHAR</a>,startTime,120) and DATA_TIME <<a href="https://www.baidu.com/s?wd=CONVERT&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1d9PynLmhRYuW6knjKBPAN-0ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EPH6zPHDvnjnsPHn4P1fkPHmd" target="_blank" class="baidu-highlight">CONVERT</a>(<a href="https://www.baidu.com/s?wd=VARCHAR&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1d9PynLmhRYuW6knjKBPAN-0ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EPH6zPHDvnjnsPHn4P1fkPHmd" target="_blank" class="baidu-highlight">VARCHAR</a>,endTime,120)本回答被网友采纳