Database Date Field Naming Convention

Naming is hard. When it comes to naming conventions, the key is to keep things simple. Here's how I like to name the date and time fields in my databases.

Database Date Field Naming Convention

I use a simple naming convention for most of my date fields:

{Past Tense Action Verb}On   -- Date only fields
{Past Tense Action Verb}At   -- Date/time fields

This tells me at a glance whether a field contains:

  • A date-only value
  • A date/time value
  • A non-date value

It also informs me of the user action that corresponds with the date/time value.

Let's say I want to keep track of when a user marked a record as inactive.  I would use one of the following field names:

  • InactivatedOn
  • InactivatedAt

What's your preferred date field naming convention?  Let me know in the comments below.

Photo by Dave Hoefler on Unsplash