%d UNIX outputs the UNIX time in seconds. %d UNIX_MILLIS outputs the UNIX time in milliseconds. The UNIX time is the real difference, in seconds for UNIX and in milliseconds for UNIX_MILLIS, between The present time and midnight, January one, 1970 UTC. Whilst the time unit is milliseconds, the granularity will depend on the working system (Windows)