Hi,
What's the right way to store time intervals in a table ?
I have a field that stores the start time of a user session , and a second field to store the session duration.
The duration field isn't a date, but a time interval, so I was thinking maybe it's a better idea to store it as an int (number of seconds).
I'm using this DB in a JAVA program, and I'm getting some troubles to show the values correctly-
What do you think is the best approach, considering duration will never be greater than 18 hours ?
Thanks in advance.
What's the right way to store time intervals in a table ?
I have a field that stores the start time of a user session , and a second field to store the session duration.
The duration field isn't a date, but a time interval, so I was thinking maybe it's a better idea to store it as an int (number of seconds).
I'm using this DB in a JAVA program, and I'm getting some troubles to show the values correctly-
What do you think is the best approach, considering duration will never be greater than 18 hours ?
Thanks in advance.