Can you correctly choose the time stamp?

326

How well do you know time standards?

If you've ever had to work with Time Series Data you may have noticed that there are a lot of different time standards. If you have multiple sources of data you'll even have to correct each data set to the same time standard. In this quiz you'll have eight unlabeled time stamps and you have to guess the correct time-time standard used to create that time stamp. Good luck!

1 / 8

#REF/#REF/#REF #REF:#REF:#REF

Mar 8th 2009 13:32:11 EST

Excel misinterpreted your date-time string and now you don't know when it is and your data is ruined

Mar 8th 2009 16:32:11 UTC

Mar 8th 2009 01:32:11 India Standard Time

Stanford Precourt Institute for Energy, CC BY 3.0, via Wikimedia Commons

I think you should be ashamed of yourself on this one, it was obviously a bad Excel time stamp. Thanks a lot Bill Gates!

Stanford Precourt Institute for Energy, CC BY 3.0, via Wikimedia Commons

You got it, but also sorry all your data's time stamps got ruined by Excel misinterpreting the date like it always does. Thanks a lot Bill Gates!

2 / 8

09/10/14 12:44:12.62

September 10th 2014 11:48:35.03 UTC

September 10th 2014 12:46:43.32 UTC

September 10th 2014 13:41:16.89 UTC

September 10th 2014 12:44:12.62 UTC

Oh no, you forgot that the computer that recorded this time stamp is on Daylight Savings Time despite reporting being on UTC and also has a 4 minute 22.41 second clock error! Better luck next time

You're pretty lucky on this one for correctly guessing that this is a time stamp from a computer on DST with a 4 minute 22.41 second clock error

3 / 8

1603223626

Jan 6th 2003 22:36:26 Tokyo Time

28 September 2010 14:07:06 GPS Time

Oct 20 2020 15:53:46 Unix Time

Jan 6th 2003 22:36:26 UTC

Woops, looks like you didn't realize that 1603 was the number of GPS weeks and 223626 the number of week seconds since Jan 6 1980

Wow look at you adding up 1603 weeks and 223626 seconds since 1980 that fast!

4 / 8

Feb 27 2008 14:32:19.82

International Atomic Time

Julian Time

UTC time

New York Time

Sorry but this time did not include leap seconds and is International Atomic Time. Maybe if Cesium decayed at a more predictable rate you would have guessed correctly

Congratz, you realized that this time stamp did not include leap seconds and is International Atomic Time!

5 / 8

2020 Oct 8th 03:22:18.61

2020 Oct 8th 03:22:18.61 UT1 (Universal Time but observed as the diurnal motion of stars then corrected for the effects of polar motion on the longitude of the observing site)

2020 Oct 8th 03:22:18.61 Greenwich Mean Time

2020 Oct 8th 03:22:18.61 Mean Solar Time

2020 Oct 8th 03:22:18.61 Universal Time

2020 Oct 8th 03:22:18.61 Sidereal time

Dang, you must have thought this time referenced the earths rotation in relation with the sun but it wasn't. This is sidereal time which uses the stars to calculate time 🙁

Nice job, you got it! This time was in fact calculated using a 23 hour 56 minute and 4 second earth rotation in relation to the stars and not the sun

6 / 8

18:42:55.2 09 June 13

June 9th 2013 18:42:55.2 GMT

June 13th 2009 18:42:55.2 Zulu Time

June 13th 2009 18:42:55.2 UTC

June 9th 2013 18:42:55.2 Central DST

Sorry but this time stamp was an hour faster than it should have been making it Daylight Savings time and not UTC/Zulu/GMT which are the same thing. Thanks a lot for complicating our time standards George Vernon Hudson! (No, Ben Franklin did not invent DST)

Nice job recognizing that this time stamp was an hour faster than normal Central time. Thanks a lot for complicating our time standards George Vernon Hudson! (No, Ben Franklin did not invent DST)

7 / 8

071102120404

Feb 20 4223 05:00:05 Unix time

July 11th 2002 12:04:04 International Atomic Time

December 4th 2004 01:11:02 DST

July 11th 2002 12:04:04 UTC

Sorry, without any reasonable markings this time stamp is obviously unix time for the year 4223

Nice, you recognized that this is a unix time stamp set in 2202 years!

8 / 8

1168064370823

Jan 10, 2017 06:19:12 GPS timestamp in seconds

Jan 10, 2017 06:19:12 GPS timestamp in miliseconds

Sat Jan 06 2007 06:19:30 Unix time in seconds

Sat Jan 06 2007 06:19:30 Unix time in nanoseconds

Sorry but this was milliseconds since Sunday 6 January 1980

Way to go recognizing that this was GPS time (milliseconds since January 6th 1980)

Your score is
The average score is 33%
LinkedIn Facebook Twitter VKontakte

0%

If you enjoyed this clickbait quiz please like, share, and subscribe with your email, our twitter handle (@JABDE6), our facebook group here, or the Journal of Immaterial Science Subreddit for weekly content.

If you REEEEALY love the content, for the equivalent price of a Chipotle Burrito, chips and Queso, you could buy our new book Et Al with over 20 hand picked Jabde articles for your reading pleasure, it’s the perfect Christmas/Birthday gift for confusing your unsuspecting family members! Order on amazon here: https://packt.link/at4bw Please rate and review so that you can brag to your friends about having opinions or showcase your excellent taste in reading material!

Like this:

Published by B McGraw

Leave a ReplyCancel reply

Share this:

Like this:

Published by B McGraw

Leave a ReplyCancel reply