How to Convert UNIX EPOCH Time Values for DEVTEST into Excel/Windows Time Formats

Products

• Service Virtualization

Issue/Introduction

Epoch / UNIX time  is used in DevTest Database TIMESTAMP Tables and is not in human readable format.  It is the number of seconds that has elapsed since 1/1/1970. 

For example

Epoch time 1672930100877    is   January 5, 2023 2:48:20.877 PM    using the Epoch Converter  : https://www.epochconverter.com/

How to convert this into EXCEL time/date format. 

 

Environment

All supported DevTest releases. 

Resolution

May use the below function in EXCEL sheet to see the actual Dates  : 

Formula "=TEXT((A2/86400000+25569),"dd/mm/yyyy hh:mm:ss")"    where A2 contains the UNIX time should convert to Excel date/time

This field is being exported correctly, so will need to add a new column in Excel and use the formula above.