How to decode the numbers to date in SD files ?

Document created by guije03 Employee on Jan 25, 2016
Version 1Show Document
  • View in full screen mode

Dates are coded as numbers with 10 digits (3*********) in some SD files like under SWJORDER (*.xml and *.apc) or under DSM\Agent\units\00000001\usd\sdjexec (*.crf).

 

Examples :

 

- File C:\Program Files\CA\DSM\ServerDB\SWJORDER\35F0D39C-A47E-4F22-A69A-4BE3275025AF\appl.apc

 

2.jpg

 

- File C:\Program Files\CA\DSM\Agent\units\00000001\usd\sdjexec\7F686775-FADF-4DE8-82A5-0A1AB65D5FF5.crf

 

3.jpg

 

 

 

How to convert these numbers to date ?

 

 

 

Instructions: 

 

Using Microsoft SQL Server Management Studio it is possible to convert these numbers in date :

Execute this query by replacing the number in bold by the number to convert

 

 

SELECT dateadd ( ss, number - 2000000000 + datediff(ss,getutcdate(),getdate()), convert(datetime,dateadd ( ss, 2000000000, convert(datetime,'19010101'))))

 

Example :

 

4.jpg

Attachments

    Outcomes