Embodiments are provided for date and time handling. In some embodiments, a timestamp and a location of creation for a content item is received, a time zone offset is retrieved for the location, the timestamp is converted into a local date and time using the time zone offset, and the local date and time and the time zone offset are used to create a value for a temporal identifier, and the temporal identifier is stored for the content item.