'unix_timestamp' is the date and time in seconds since Jan 1, 1970. While you can format it or convert it to be 'human readable', it is time. And since it is a single number, it sorts very well. Other formats probably convert to unix_timestamp for most operations.