%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, amongst The existing time and midnight, January 1, 1970 UTC. When time unit is milliseconds, the granularity will depend on the operating method (Home windows). Thi