Time calculation: type date or timestamp; how to calculate time in between?
Dear experts,
I like to create a simple flightbook table: FLIGHTID, TAKEOFFTIME, LANDINGTIME.
1. First question:
I prefer to use UTC as timezone in the app.
Which datatype would be best to take?
date or timestamp?
2. Secound question:
I like to calculate the flighttime between TAKEOFFTIME, LANDINGTIME?
How do I do this best?
Add a column flighttime?
How do I calculate the flighttime between TAKEOFFTIME, LANDINGTIME?
Advice and tips are very welcome!
Kind regards
Lorenz
--