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

All original code samples by Mike Wolfe are licensed under CC BY 4.0