Understanding the difference between "Time" and "TimeStamp"


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"


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.


Was this article helpful?
0 out of 0 found this helpful



Please sign in to leave a comment.