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?
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.