Date + Time vs. Timestamp
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.