Hello,
In Zephyr test case Schedule table (AO_7DEABF_SCHEDULE) last execution date is stored in numeric format. Column name is Executed_On. How can we extract the corresponding date to that numeric field so that we can extract and display in report when was the last execution happen to that test case issue in Jira.
Below is an example of the value for that column that is stored in the DB.
1558517155437
Thanks,
Mani
Hello,
This is numeric format of date and time. This is used to calculate the time irrespective of TIME Zones.
You can checkout the time using https://www.epochconverter.com/ by entering that numeric value.
SQL QUERY:
SELECT ID, from_unixtime((EXECUTED_ON div 1000)) FROM ao_7deabf_schedule;
Above query returns ID, Time in readable format.
494 | 2020-02-25 14:59:26 |
495 | 2020-02-25 15:00:57 |
496 | 2020-02-25 15:01:18 |
Regards
Neelakanta
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.