I am trying to understand the below query being run from our developers on read only database which just runs forever.

Table here is partitioned table on partition column trickey per day.

Query is something like below

Select a,b,c,d,trickey from table where (1=1) AND (1=1) and convert( varchar(10),trickey,112) BETWEEN 20190913 and 20190913

Will above query not eligible for partition key elimination?