[Answered ]-Use Like on Date in sql query

by

1👍

✅

You could send dates that are outside the current date range, but you nned to change the app when it comes to year 9999

SELECT survey_id, orchardist_name, village,
panchayat, dev_block, tehsil, district, survey_id AS ACTION
FROM hd_survey_head WHERE created_on BETWEEN '1899-12-31' AND '9999-01-01' 
AND dev_block='CHAUPAL' AND panchayat LIKE '%%' AND village LIKE '%%'
👤nbk

Leave a comment