Guys, such a question, there is an entry in the plate with time, well, for example: 2006-02-12 11:50:51 . How to make all entries that are more than two days removed? What need to formulate a request?

    1 answer 1

    The main thing here is to correctly formulate the question, not the request. :)

     delete from 'tname' where dtame<='2 дня'

    I advise you to use the INT () field and store the timestamp instead of the datetime field there, and it's easier to work with it.

    • the button under the answer is “accept” or +1 to put :) well, as usual, good people do everything;) - Artem
    • I agree, you need to formulate the question correctly. Do they need to be deleted or is the request needed?) - namak