How to extract date from a table where the date is stored in Numeric format

[Mani]

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

[Neelakanta Reddy M]

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

[Mani]

Thank you.