I have a sql table that will contain appointment, date and time. I keep all three based on ID. I have a question regarding date and time.
id = 0; data 28/08/2018 - 13:11h id = 1; data 26/08/2018 - 17:10h id = 2; data 25/08/2018 - 11:15h
I want to organize the table this way:
id = 0; data 25/08/2018 - 11:15h id = 1; data 26/08/2018 - 17:10h id = 2; data 28/08/2018 - 13:11h
Because when I schedule a time and a date, I might have a clue to set the next alarm based on id 0. I am having problems with this, because when I save a date and a time, I do not know which one call