Time format for Exports

Report issues relating to bandwith monitoring, bandwidth quotas or QoS in this forum.

Moderator: Moderators

Post Reply
zual
Posts: 4
Joined: Sun Apr 07, 2013 2:03 am

Time format for Exports

Post 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

zual
Posts: 4
Joined: Sun Apr 07, 2013 2:03 am

Re: Time format for Exports

Post by zual »

Any clues anyone? Just can't find anything anywhere that allows me to translate this number into a meaningful date.

Regards

BashfulBladder
Moderator
Posts: 250
Joined: Thu Jan 17, 2013 11:43 pm

Re: Time format for Exports

Post 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/
TP-Link WDR3600 v1.1 running 1.5.10+ L10n-English (Built 20130922 - OpenWrt r38093)
TP-Link WDR4300 running 1.5.10+ i18n-English (Built 20131010 - OpenWrt r38286)

https://github.com/BashfulBladder/gargoyle-plugins/wiki

zual
Posts: 4
Joined: Sun Apr 07, 2013 2:03 am

Re: Time format for Exports

Post by zual »

Great I really appreciate your help
Thanks

Post Reply