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, ∼9018🔥, 0💬
Popular Posts:
Where to find tutorials on Test Management? I want to know how to manage software testing documents ...
How to generate user birthday dates? Test user birthday dates are frequently needed in testing appli...
How to generate IP Addresses? To help you to obtain some IP addresses for testing purpose, FYIcenter...
How to validate email address format? In order to help your programming or testing tasks, FYIcenter....
How to expand IPv6 addresses? In order to help your programming or testing tasks, FYIcenter.com has ...