All individual subscriptions are 50% off this week only!

swapna
11 months ago

date filter

Posted 11 months ago by swapna

select * from assignment where (assignment.agency_id = '102' and assignment.status = '1' and assignment.is_deleted = '0') and assignment_start_date >= '2018-01-01' and assignment_end_date <= '2018-06-05' .I wrote query like this but i have more than 10 assignments in this '2018-01-01'.but result is only one record "2018-01-01", " 2018-05-31"

Please sign in or create an account to participate in this conversation.