Google default time format?

  • Thread starter WWGD
  • Start date
  • #1
WWGD
Science Advisor
Gold Member
5,673
5,765
Summary:
How to decode Google time into Human.
Hi,
Just opened some .xml file in which time is given as a 10 digit number starting with 1570. I assume it represents the number of seconds from some baseline date. Anyone know if this is it and if so, the baseline date?
Thanks.
 

Answers and Replies

  • #5
pbuk
Science Advisor
Gold Member
2,626
1,323
Thank you. Just looked it up , it is the number of seconds from/since January 1 00:00 . I will start using it ;).
Yes, Unix time is the number of seconds since 00:00 on 1 January 1970. Note that leap seconds are ignored i.e. each day in Unix time is exactly 86,400 seconds.
 
  • #6
WWGD
Science Advisor
Gold Member
5,673
5,765
Yes, Unix time is the number of seconds since 00:00 on 1 January 1970. Note that leap seconds are ignored i.e. each day in Unix time is exactly 86,400 seconds.
Yes, thanks, my bad, I just edited. it seems kind of a pain to go back and forth between the dating systems. I guess we divide by 31557600 and add the quotient to 1970, then we kind of run into issues with the remainder since months have unequal number of days. Not impossible but doesn't seem straightforward. Sure someone has come up with a nice enough translator. Edit: Will look one up and post it if I find one when I get more time.
 
  • #7
pbuk
Science Advisor
Gold Member
2,626
1,323
There's actually a cunning formula which I can't lay my hands on at the moment, but conversion functions exist for most languages, or you can use any of many online converters (search 'unix converter' or 'epoch converter').

Edit: or use this one:
 
Last edited:

Related Threads on Google default time format?

Replies
2
Views
3K
  • Last Post
Replies
2
Views
3K
  • Last Post
Replies
2
Views
2K
  • Last Post
Replies
1
Views
6K
  • Last Post
Replies
5
Views
28K
  • Last Post
Replies
3
Views
4K
  • Last Post
Replies
11
Views
2K
  • Last Post
Replies
16
Views
3K
  • Last Post
Replies
5
Views
2K
  • Last Post
Replies
3
Views
3K
Top