Google default time format?

  • Thread starter WWGD
  • Start date
  • #1
WWGD
Science Advisor
Gold Member
6,197
7,718
TL;DR 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
3,877
2,254
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
6,197
7,718
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
3,877
2,254
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:

Suggested for: Google default time format?

  • Last Post
Replies
10
Views
505
  • Last Post
Replies
2
Views
587
  • Last Post
Replies
2
Views
601
Replies
3
Views
503
Replies
32
Views
3K
  • Last Post
Replies
16
Views
2K
Replies
15
Views
579
  • Last Post
Replies
4
Views
1K
  • Last Post
Replies
5
Views
944
Top