Highlighted

datemodified of file cataloged in fh

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 Solution

Accepted Solutions
Accepted Solution!

Re: datemodified of file cataloged in fh

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

Re: datemodified of file cataloged in fh

Try using PowerShell

Re: datemodified of file cataloged in fh

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

Re: datemodified of file cataloged in fh

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?

Re: datemodified of file cataloged in fh

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.


 

Accepted Solution!

Re: datemodified of file cataloged in fh

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