How do you name fields like timestamp?

Question

SQL

Let's say for the post publication date in the post table:
pub_date / pub_time? but it's not just a date or time, but a date and time
pub_datetime / pub_timestamp? somehow a lot of letters
What if you do not specify the type in the suffix:
published? and if you also need the fact of publication published as boolean?
maybe published_dt or published_at?
I admit that I bother a lot, but suddenly there is a best practice among experienced developers in this regard and I will know for sure that kittens will not die because of me.
And yes, I googled, but I didn’t see a consensus ( https://dba.stackexchange.com/questions/2677/how-s...

Answer 1

I have published_at - timestamp, published_date and published_time - derived properties, published - status (boolean)