I have a list with data selected from date, the date field is of type DATETIME.
FECHA 15-08-2017 14:41:12;
ID 150;
DATO 80
Out of a total of 1000 records, it is necessary to know how many times the value of the DATA field changed and what values it had at a certain date and time.
I was thinking about separating the DATE field that is of the DATETIME type and extracting only the date and time to obtain the results only from the data that changed. For that I was thinking about using DATE_FORMAT, but I can not get my query to work.