11-12-2015 12:22 AM
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?
Solved! Go to Solution.
11-12-2015 02:45 AM
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
11-12-2015 12:41 AM
11-12-2015 01:07 AM
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
11-12-2015 02:04 AM
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?
11-12-2015 02:11 AM
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.
11-12-2015 02:45 AM
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