%d UNIX outputs the UNIX time in seconds. %d UNIX_MILLIS outputs the UNIX time in milliseconds. The UNIX time is the difference, in seconds for UNIX and in milliseconds for UNIX_MILLIS, involving The present time and midnight, January one, 1970 UTC. When time device is milliseconds, the granularity is dependent upon the working procedure (Windows).