I have date-time field in my database like that 2023-01-18 05:43:18 and I want to subtract this field from the current date and time using and sql query to get result when the difference from this field less than one minute .
>Solution :
Use TIMESTAMPDIFF to calculate the difference:
TIMESTAMPDIFF(MINUTE, localtimestamp, columnname) AS difference
localtimestamp gives you the current date and time (without timezone information.) You can also use current_timestamp if you want the timezone.
https://learnsql.com/cookbook/how-to-calculate-the-difference-between-two-timestamps-in-mysql/