Data Types for columns

[ironcurtain]

I am looking to create columns in a database for the variables listed below, but I'm not sure what data type to use for each.
Are there any suggestions, please?


%CurrentStatusDuration%
%CurrentStatusDuration_sec%
%PreviousStatusTime%
%PreviousStatusDuration%
%PreviousStatusDuration_Sec%
%AliveTime%
%DeadTime%
%UnknownTime%
%StatusChangedTime%

[KS-Soft]

%CurrentStatusDuration% returns string like "82 days 19:22:57" so you should use varchar data type
%CurrentStatusDuration_sec% returns integer number so you may use some numeric type

%PreviousStatusTime%
%PreviousStatusDuration%
%PreviousStatusDuration_Sec%
these variables may return empty string, use varchar

%AliveTime% - varchar
%DeadTime% - varchar
%UnknownTime% - varchar

%StatusChangedTime%
You may use datetime or timestamp type for this field

Regards
Alex