I normally name DATETIME columns as ACTION_WORD_on: created_on, completed_on, etc.
The ACTION_WORD
defines what the column represents, and the suffix (_on
) indicates that the column represents time.
Other suffixes (or even prefixes) may be used to specify the data type (_at
, _UTC
, when_
, etc).
Be descriptive. Be consistent.