UNIX timestamp conversion problems company projects need to query databases far away from the United States, while the database stored over there is stored in the local timestamp. When querying data, a problem occurs, if a date like query is different from a UNIX timestamp query result, how can this time difference be processed? First, we need to understand two concepts: Date and UNIX timestamp. The date is sometimes differentiated. For example, here we are 23:33:23 and the date in the United States is: 10:33:23, that is, the United States uses the time zone (West five) 13 hours later than the GMT +. The UNIX timestamp refers to the number of seconds that have elapsed since January 1, January 1, 1971. There is no time zone difference, that is, the timestamp at a certain time point is globally unified. For example, if our timestamp is 1000000, our date is 23:33:23, and the U.S. timestamp is 1000000, and their date is 10:33:23, to wait until their date is 23:33:23, the timestamp will be: 1000000 + 3600*13, therefore, we need to add the time stamp of the 13-hour difference when we query the date here, instead of subtracting it.