Workplace Experience Sharing--Details that are easily overlooked when checking data by timestamp in the interface

Background

Generally, when the data in a table needs to be obtained from external/downstream interfaces, a series of interfaces will be designed, which may include paging query by primary key, incremental data query by update time, etc.If the table involves time fields, such as updateTime, and the business involves multiple countries, the time may be converted to 0 time zone for storage.In this case, it is also to be able to do corresponding processing according to the local time zone when the time is displayed in other places later.

Next, I will share a small detail that I overlooked when testing an interface today

If I now want to test an interface that obtains incremental data according to the timestamp of the specified updateTime, one of the test scenarios is: find the record with the largest updateTime from the table, and then convert this time into a timestamp to callInterface to check whether the update time of the returned data is >= the time corresponding to the incoming timestamp.

Assume that the time when the database is found is 2022-08-04 01:11:30, and then I found a timestamp conversion tool on the Internet. The problem appeared on the conversion tool I was looking for:

I compare the timestamp of Beijing time converted by this URL with the data in the database. It is actually wrong. The corresponding time should be converted to the timestamp of time zone 0, yesConvert with the following address: https://www.baidufe.com/fehelper/timestamp/index.html

Or, you need to add a time difference of 8 hours to the timestamp of Beijing time, that is, add 8 * 3600 * 1000 milliseconds.

The above is a small detail that I overlooked when I was testing the interface today. Of course, you can also modify the description, and change it to a certain function in the system due to a similar reason. There is a bug, and moreA bug that impresses you.

If you think the article is helpful to you, please like, forward and support it~

Past recommendations

Those bugs that impressed me--01

The bugs that impressed me--02

Those bugs that impressed me--03

Those bugs that impressed me--04

Those bugs that impressed me--05