Hello, How to perform DateDiff - SQL functions in ...
# orm-help
d
Hello, How to perform DateDiff - SQL functions in Prisma ? I could not find the docs related to it ๐Ÿ˜ž For Example: I have a query
Copy code
SELECT *
FROM employees
WHERE DATEDIFF(hire_date, STR_TO_DATE('2021-01-01', '%Y-%m-%d')) >= 0
Anyone has the solution for it ?
h
I donโ€™t see any reason to use
DATEDIFF
here (or
STR_TO_DATE
). You could just use
gte
for the
hire_date
๐Ÿ‘ 1
d
Ok ๐Ÿ™‚
Thank you @hela