The most interesting case of a time format for storage was the time they were shot for uploaded photos. The best answer was effectively save it as a local string. Together with the location it fully 'captures the moment'. This was apparent when showing new year's celebration photos with a date-time in the viewers timezone.