CODEWITHSUNDEEP
ruby-on-railsjsondate
Teo Choong Ping
Teo Choong Ping

Reputation: 12798

What date format is this?

I have a web service returning JSON data with some date fields but I couldn't recognize the date format to parse this date field.

2010-11-05TNov:10:1288995006 UTC
2010-10-28TOct:37:1288301863 UTC
2010-10-05TOct:33:1286314434 UTC

Upvotes: 2

Views: 328

Answers (3)

Stephen C
Stephen C

Reputation: 718758

I think you are asking the wrong people. You should really be asking whoever is responsible for creating the web service where there documentation is and / or what format the timestamps are supposed to be.

(FWIW - I agree with the consensus that the timestamp format is probably erroneous.)

Upvotes: 0

miku
miku

Reputation: 188014

The first epoch (1288995006) translates to

Fri, 05 Nov 2010 22:10:06 GMT

Seems, somebody obfuscated or messed up the human readable month part - 22 would make more sense than Nov. If you care about the date, I'd suggest you go with the epoch.

Sidenote:

If a date and a time are displayed on the same line, then always write the date in front of the time. If a date and a time value are stored together in a single data field, then ISO 8601 suggests that they should be separated by a latin capital letter T, as in 19951231T235959.

Upvotes: 2

Michael Trausch
Michael Trausch

Reputation: 3165

That is a quite weird timestamp, isn't it.

yyyy[-]mm[-]dd"T"hh":"mm":"ss.nnnnnn"Z" is an ISO standard date format (ISO 8601), which is similar to what appears in the first field of that... but it has what appear to be three field groups, holding what appear to be:

yyyy-mm-dd"T"MMM:??:POSIX-TIMESTAMP UTC

The current time being 1292563122, those would appear to have been generated 3,568,116 seconds (or approximately 41 days) ago.

Hope this helps.

Upvotes: 5

Related Questions