How can I obtain timestamps in useful format when exporting data from device cloud?

When data streams are exported from device cloud, the timestamp format is not in a useful format. Can anything be done to convert this or to export data in a manner that translates timestamp correctly?

The timestamp is in EPOCH format, that means it’s a “long” integer of the amount of miliseconds that have passed since January 1st, 1970.
There are differente libraries for parsing EPOCH timestamp into other formats. It depends on the programming language.

here is something in python close to what you want.:

takes the number of seconds since 1900 jan 1st 00:00:00 and returns it

as a string representation in the form “Sat Jun 27 13:13:41 2009”

def parseNTPResponse(data):
TIME1970 = 2208988800L
t = struct.unpack( ‘!12I’, data )[10]
t -= TIME1970
timeString = ‘%s’ % time.ctime(t)
print "timeString = ", timeString
return timeString