Take the 2-minute tour ×
English Language & Usage Stack Exchange is a question and answer site for linguists, etymologists, and serious English language enthusiasts. It's 100% free, no registration required.

I'm looking for a simple word for a point in time for the name of a database column. The column is for "datetime" objects and it feels wrong to call the column "date", since that implies that the column only contains dates, and similarly it feels wrong to call the column "time". General programming principles dictate that it's also a bad idea to name a column simply by the value type it contains, so I don't want to name it "datetime".

Is there an English word for a "point in time", independent of whether we're talking about time of day, date of year or millennia? I want the word (X) to fit into the column name "creation_X". If you have another idea of a good naming choice I'd love to hear that too.


Edit: The table column in question should specify when the data was recorded. Think of it as a data point for Google Analytics. A row contains, for instance, site visits for 12:00 to 13:00 on 2013-01-01, so the field "time_span" is set to "hour", and the field for column X should be set to "2013-01-01 12:00:00". I can't figure out what to call the column though.

share|improve this question
    
If you are supposed to use a particular style of name (eg noun, noun phrase, verb, etc) or particular orthography, please edit question accordingly. Eg, indicate if a title like “When Created” is acceptable. –  jwpat7 Apr 23 '13 at 17:28
3  
Moment theoretically has that meaning, but I'm not sure how well it would do in context. –  onomatomaniak Apr 23 '13 at 17:38
    
@jwpat7: Thanks for the feedback, I've updated the question. –  Hubro Apr 23 '13 at 17:44
    
Also see english.stackexchange.com/q/164227/8278 –  Pacerier May 24 at 19:33
add comment

2 Answers 2

up vote 3 down vote accepted

Timestamp is the word universally used for precisely that, especially in programming context.

share|improve this answer
    
Won't it be confusing to name the column "timestamp" when the data type is "datetime" and a type called "timestamp" exists? Otherwise I agree with you though –  Hubro Apr 23 '13 at 17:46
1  
@Codemonkey You could call it creation_timestamp if you are concerned. Reg is right, this is the most common term. –  KitFox Apr 23 '13 at 18:17
    
@KitFox: OK, thanks for your help. –  Hubro Apr 23 '13 at 18:33
add comment

"Moment" is a good word for a point in time. And it accepts adjectivals gracefully:

  • beginning moment
  • critical moment
  • Moment of creation
  • Moment of genesis
share|improve this answer
    
I have a column called "Moment" which records the date/time. Isn't that odd-sounding? –  Pacerier May 24 at 19:28
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.