Problem
The "Time" and "TimeStamp" attributes are similar but not the same. This explains how to decide when to use "Time" and when to use "TimeStamp"
Solution
TIMESTAMP is used for values that contain both date and time parts.
TIMESTAMP has a range of '1970-01-01 00:00:01' UTC to '2038-01-19 03:14:07' UTC.
TIME is listed in 'HH:MM:SS' format (or 'HHH:MM:SS' format for large hours values).
TIME values may range from '-838:59:59' to '838:59:59'.
Reltio recommends using TIMESTAMP if your data contains both date and time, else TIME if your data contains only time/hours.
Comments
Please sign in to leave a comment.