AnsweredAssumed Answered

Date + Time vs. Timestamp

Question asked by DanF on Feb 23, 2012
Latest reply on Feb 23, 2012 by philmodjunk

Title

Date + Time vs. Timestamp

Post

New FileMaker user here with a quick question. If I inderstand correctly, it is wise to add record creation and record last modified dates or timestamps as fields in each table. What option, then, should I choose? Is there any reason to simply pick date instead of a full blown timestamp?

Please give examples of each if possible. As one who is new to database design, I want to do it right from the start. To me it seems like choosing Timestamp is logical because there must be a way to display just the date or time (i.e. separate out the two) should I decide to display the field on a layout.

Outcomes