The "ILM" chapter in the Admin Guide has some tips, among which: 18. You can convert a time interval value to a number of seconds with the SQL cast syntax, as in the following example:
define([toSeconds],[(($1) SECONDS(12,6))]) define([toUnixSeconds],[toSeconds($1 - ’1970-1-1@0:00’)]) RULE external list b RULE list b SHOW(’sinceNow=’ toSeconds(current_timestamp-modification_time) ) RULE external list c RULE list c SHOW(’sinceUnixEpoch=’ toUnixSeconds(modification_time) ) The following method is also supported: define(access_age_in_days,( INTEGER(( (CURRENT_TIMESTAMP - ACCESS_TIME) SECONDS)) /(24*3600.0) ) ) RULE external list w exec ’’ RULE list w weight(access_age_in_days) show(access_age_in_days) --marc of GPFS
_______________________________________________ gpfsug-discuss mailing list gpfsug-discuss at spectrumscale.org http://gpfsug.org/mailman/listinfo/gpfsug-discuss
