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, 7642🔥, 0💬
Popular Posts:
How to Pass Windows Environment Variable to JMeter? I want to use Windows temporary folder environme...
How to valid UUID/GUID strings? In order to help your programming or testing tasks, FYIcenter.com ha...
How to valid IPv6 addresses? In order to help your programming or testing tasks, FYIcenter.com has d...
How to convert hexadecimal encoded data back to binary data (or Hex to Binary Decoding)? Hex to Bina...
How to validate and decode MAC (Media Access Control) addresses? In order to help your programming o...