I want to predict the time corresponding to a specific value.
I plan to travel a total distance of about 100 km. The first 6 hours will be on foot, and the rest by car.
Assuming the car’s speed is fairly consistent, I want to create a simple model to predict the date and time (yyyy-mm-dd hh:mm:ss) when I will reach the 88 km mark.
Fortunately, I can obtain distance data every second. I think I can create a linear regression curve by using `DATETIME` on the Y-axis and distance on the X-axis.
However, I can't seem to use `DATETIME` on the Y-axis. What should I do?