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?