select *
from table_name a
where a.dt_start <= :date
and (a.dt_end is null or a.dt_end >= :date);
select *
from table_name a
where a.dt_start <= :period_end
and (a.dt_end is null or a.dt_end >= :period_start);
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.