表:tb
schedule filmname
2007-7-1 10:00 dragon
2007-7-1 16:00 tigger
2007-7-2 11:00 cat
2007-7-2 15:00 dog要求根据日期(2007-7-1或2007-7-2)查出当天所有电影的开播时间,如2007-7-1对应:10:00 和16:00
用like设定条件,不要用between(这个笨方法我也想到了)。我想用的语句是:
select hour(schedule),minute(schedule) from tb where schedule like '2007-7-1%'
但得不到结果,另外小时和分钟数也合不起来!
schedule filmname
2007-7-1 10:00 dragon
2007-7-1 16:00 tigger
2007-7-2 11:00 cat
2007-7-2 15:00 dog要求根据日期(2007-7-1或2007-7-2)查出当天所有电影的开播时间,如2007-7-1对应:10:00 和16:00
用like设定条件,不要用between(这个笨方法我也想到了)。我想用的语句是:
select hour(schedule),minute(schedule) from tb where schedule like '2007-7-1%'
但得不到结果,另外小时和分钟数也合不起来!
from ta
where datediff(d,schedule,'2007-7-1') = 0
from tb
where datediff(d,schedule,'2007-7-1') = 0
where 有时候笨办法更合理
from tb
where datediff(d,schedule,'2007-7-1') = 0
where schedule like '2007-7-1%'
from ta
where datediff(d,schedule,'2007-7-1') = 0
加颜色部分不懂,应该只有两个参数呀!