Page 1 of 1

Time format for Exports

Posted: Mon Apr 15, 2013 3:32 am
by zual
Hi,

I am exporting Visited Sites from Web Usage tab. Could you advise what format the date and time is in, all I see in the exported file is a large number eg 1365990633.

Thanks

Re: Time format for Exports

Posted: Mon Apr 15, 2013 9:47 pm
by zual
Any clues anyone? Just can't find anything anywhere that allows me to translate this number into a meaningful date.

Regards

Re: Time format for Exports

Posted: Wed Apr 17, 2013 12:00 am
by BashfulBladder
Linux #seconds since 1970-01-01 00:00:00 UTC :

date "+%s"
1366170787

You have to work the math out to figure out which day by accounting for years, leap days, that sort of stuff.

http://www.epochconverter.com/

Re: Time format for Exports

Posted: Wed Apr 17, 2013 3:59 am
by zual
Great I really appreciate your help
Thanks