Ask HN: Timestamp vs. millis, storing time in database Ok. this question usually come to my mind and always I prefer using millis because I think that is the easiest way to store and get the time in database. But some of my friends prefer using timestamp. So I just wanted to know, What is the best practise for storing time in database ? When choosing between timestamp and millis which one you prefer using and why? |
Using the native DBMS types allows use of native DBMS time and interval functionality, unless you like doing it yourself.
See also [2]
[1] https://www.postgresql.org/docs/9.6/static/datatype-datetime...
[2] http://stackoverflow.com/questions/409286/should-i-use-field...
I have asked this question so that I can know whether any other person faces problem like this, it is kind of annoying when I see different ways of storing the time, but not knowing what is the best practise to save time in database.