Question

sql语句当前时间大于开始时间start_date 小于结束时间end_date 表名是BASE_ORGANIZATION 怎么写

Answer 1

sql server
select * from BASE_ORGANIZATION where start_date<getdate() and end_date>getdate()

oracle
select * from BASE_ORGANIZATION where start_date<sysdate and end_date>sysdate

Answer 2

select * from BASE_ORGANIZATION where getdate()>startdate and getdate()<end_date

Answer 3

SELECT *
FROM BASE_ORGANIZATION
WHERE GETDATE()>start_date and GETDATE()<end_date