Convert JMeter Timestamp to Date and Time

Q

How to Convert JMeter Timestamp to Date and Time in MySQL? I see the timestamp is stored as an integer in database.

✍: FYIcenter.com

A

The JMeter timestamp is an integer representing how many milliseconds have been passed since 01-Jan-1970 00:00:00 UTC time.

You can use the from_unxtime() function in MySQL to convert JMeter timestamp to nice date and time format as shown below:

mysql> select from_unixtime(timeStamp/1000), elapsed, label, success 
   from jmeter_test_result order by timeStamp desc limit 0,10;

+-------------------------------+---------+----------+---------+
| from_unixtime(timeStamp/1000) | elapsed | label    | success |
+-------------------------------+---------+----------+---------+
| 2017-11-17 21:05:05.7700      |     365 | Google   | true    |
| 2017-11-17 21:05:05.6660      |     457 | Google   | true    |
| 2017-11-17 21:05:04.2320      |    1537 | Facebook | true    |
| 2017-11-17 21:05:04.1710      |    1494 | Facebook | true    |
| 2017-11-17 21:05:03.8020      |     430 | Google   | true    |
| 2017-11-17 21:05:03.7300      |     441 | Google   | true    |
| 2017-11-17 21:05:03.7080      |     453 | Google   | true    |
| 2017-11-17 21:05:03.6750      |     468 | Google   | true    |
| 2017-11-17 21:05:03.6370      |     496 | Google   | true    |
| 2017-11-17 21:05:03.5740      |     515 | Google   | true    |
+-------------------------------+---------+----------+---------+
10 rows in set (0.00 sec)

 

Add Custom Field to JMeter Test Result

Auto Flush JMeter Test Result to File

Saving Test Results to MySQL Database

⇑⇑ Apache JMeter Tutorials

2017-11-18, 833👍, 0💬