sql时间段的比较

[袁择]

有个问题请教各位大神，如何判断当前时间是否在between_time 和 end_time之间，用sql怎么写。先谢谢大家的回答

[二月十六]

--mssql
SELECT  *
FROM    表
WHERE   GETDATE() BETWEEN between_time AND end_time
--mysql
SELECT  *
FROM    表
WHERE   now() BETWEEN between_time AND end_time

[听雨停了]

WHERE   GETDATE() BETWEEN begin_time AND end_time

是begin_time吧不是between_time吧

[袁择]

谢谢，问题解决了