Spring Data Jpa – MSSQL creteriabuilder function
SELECT code FROM usertype WHERE CAST(CONVERT(varchar, CREATEDATE, 120) as date) = CAST(CONVERT(varchar, ‘2024-07-08’, 120) as date); I want to write expression for the condition ‘CAST(CONVERT(varchar, CREATEDATE, 120) as date) = CAST(CONVERT(varchar, ‘2024-07-08′, 120) as date)‘ found in the query above. I tried different solutions but I couldn’t get it to work properly. private static Predicate […]