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, 6861🔥, 0💬
Popular Posts:
How to generate ISBN numbers? To help you to obtain some ISBN numbers for testing purpose, FYIcenter...
How to convert hexadecimal encoded data back to binary data (or Hex to Binary Decoding)? Hex to Bina...
How to generate test fractional numbers? Test fractional numbers are numbers with fractions that are...
How to convert hexadecimal encoded data back to binary data (or Hex to Binary Decoding)? Hex to Bina...
How to validate Mod 10 (Luhn Algorithm) checksum? In order to help your programming or testing tasks...