SELECT * FROM PAY_ENTRIES_POST WHERE CONVERT(DATE,TRN_DATE,103) ='2022-10-26'