cancel
Showing results for 
Search instead for 
Did you mean: 

datemodified of file cataloged in fh

saj3an_qazzi
Level 3

I have used cattool.exe to convert an fh file into xml format. The xml file contains a lot of xml nodes, one of them looks like follows:

<ET ... MT=1412164908" CT=1412164908" AT=1412164908" SZ="4065" FP="WSS_Content\/\MyDocuments\myfile.docx" OST="0" />

I know that FP is "complete file path", what about MT, AT, and CT. Are these tags related to modification time, access time, creation time?

how can I convert MT=1412164908" from integer value into datetime?

1 ACCEPTED SOLUTION

Accepted Solutions

saj3an_qazzi
Level 3

Thanks a lot VJware.

Using your hint solved 90% of my problem, as follows:

--if we have a column called MT in table Catalogs

select Modification_time= dateadd(s, Catalogs.MT, '19700101')
from Catalogs

That will return the date as: example: 1446714448 will be converted to 2015-11-05 09:07:28.000

View solution in original post

5 REPLIES 5

pkh
Moderator
Moderator
   VIP    Certified
Try using PowerShell

VJware
Level 6
Employee Accredited Certified

Few of the abbr...

LB - Logical Block

AT - Access Time

CT - Change Time

MT - Modified Time

OST - If DeDupe being used, then name of the OST image

IMG - If GRT to disk being used, then name of the IMG folder

saj3an_qazzi
Level 3

using SQL, I tried casting the integer into datetime, it failed. even if I were to assume that this integer represents the milliseconds, adding this value to 01-01-1900 also resulted a date of year 1947, which is definetly wrong.

I tried to use excell to parse it as date, it also failed, the date was at 1947 something.

Monday, January 1, 0001 12:02:21 AM was the result I got from powershell

any ideas how Modified Time is represented? how can I convert it back to datetime?

VJware
Level 6
Employee Accredited Certified

MT, AT & CT uses Unix UTC date/time stamps.

1412164908 means 01 Oct 2014 12:01:48 GMT

Use an Epoch Unix converter to get the date/time in readable format.


 

saj3an_qazzi
Level 3

Thanks a lot VJware.

Using your hint solved 90% of my problem, as follows:

--if we have a column called MT in table Catalogs

select Modification_time= dateadd(s, Catalogs.MT, '19700101')
from Catalogs

That will return the date as: example: 1446714448 will be converted to 2015-11-05 09:07:28.000