I'm not sure which type I should use to work with hours on my system. Should I use
TimeStamp . I would like the hours to be saved in this format:
There is a specific type for this which is
TIME . This type has the seconds and fraction of them as well (keep them zero if you don't need them), but overall this won't be a problem.
But it is not always necessary to use it. There are some situations where a
VARCHAR type may suffice. Of course it's more limited, it doesn't have the best semantics, but it depends on usage. If you really want to avoid the seconds, it would be this way. You will have to handle the data manually.
On the other hand, it is possible that this type is not enough for what you want and you need to use another type where you have more control, even if it is at the cost of less facilities. In some cases it may be
VARCHAR itself. In others it might be interesting to use
TIMESTAMP , even if they have irrelevant information.
Just seeing the exact situation to decide which is best. But I'll go with the native types first. If so, sin for excess would be more advantageous in most cases.