How should I best name my timestamp fields?
You should describe the purpose of the column and not necessarily the data type.  You can include date/time/timestamp in the name, but you should also include the meaning.  For example


CreationDate 
StartDate 
StatusTime 
Accessed 
Updated


Adding Date/Time/Timestamp and such at the end is particularly useful when the abscence of the addition would conflict with another column.  For example, a table may need both a Status and a StatusTime.