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
⇑ Saving Test Results to MySQL Database
⇑⇑ Apache JMeter Tutorials
2017-09-15, 4680👍, 0💬
Popular Posts:
How to see my IP address Host Name? To help you to see your IP Address Host Name, FYIcenter.com has ...
What are date and time test values? Date and time test values are frequently needed in testing date ...
What are JMeter command line options? You can get see JMeter command line options by running this co...
How to generate currency test values? Currency test values are frequently needed in testing date and...
How to set Content-Type to application/json? The server requires the Content-Type to be application/...