Hello,

For storing date, date-time and time values, what data-type do you recommend? Is timestamp type a better approach for performance, ease-of-use and maintainability? Is timestamp better for a locale-specific i18n/i10n application? What happens after year 2037 that is the threshold for timestamp type?

For storing date, date-time and time values, what data-type do you recommend?

DATE, DATETIME, and TIME (respectively)


Is timestamp type a better approach for performance, ease-of-use and maintainability?

better than DATETIME? no

but TIMESTAMP can be set to update automatically


What happens after year 2037 that is the threshold for timestamp type?

nothing

perhaps you're thinking of the unix timestamp, but you need to store that type of value in an INTEGER

TIMESTAMP is different

Oops! I meant unix-timestamp as unsigned integer. Please clarify if unix-timestamp is a better approach than date/datetime types for an i18n/i10n application and for performance, ease-of-use and maintainability.

TIA

no, i don't think it is