Collections:
Convert JMeter Timestamp to Date and Time
How to Convert JMeter Timestamp to Date and Time in MySQL? I see the timestamp is stored as an integer in database.
✍: FYIcenter.com
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
2017-09-15, 7092🔥, 0💬
Popular Posts:
Where to find tutorials on Apache JMeter test tool? I want to know how to use Apache JMeter. Here is...
How to access Response Status Code 400 as Success? My sampler failed, because the server returns the...
Why I am getting gzip compressed HTTP response in SoapUI? If you run a HTTP request for some Website...
What are JMeter command line options? You can get see JMeter command line options by running this co...
How to convert hexadecimal encoded data back to binary data (or Hex to Binary Decoding)? Hex to Bina...