I want to develop a web application that needs to store dates and times, as well as to doing some calculations such as the differenece between two dates and etc.
I am not sure about the best design I can make.
- should I have two different columns: Date and Time
- should I have one column of type: DateTime
- should I have one column of type: TimeStamp
Could you please explain the best choice and why do we have these different types