Function my_decimal_from_datetime_packed

sql/sql_time.cc:1544–1567

Unpack packed numeric temporal value to date/time value and then convert to decimal representation. @param OUT dec The variable to write to. @param type MySQL field type. @param packed_value Packed numeric temporal representation. @return A decimal value in on of the following formats, depending on type: YYYYMMDD, hhmmss.ffffff or YYMMDDhhmm

              on type: YYYYMMDD, hhmmss.ffffff or YYMMDDhhmmss.ffffff.
*/
my_decimal *my_decimal_from_datetime_packed(my_decimal *dec,
                                            enum enum_field_types type,
                                            longlong packed_value)
{
  MYSQL_TIME ltime;
  switch (type)
  {
    case MYSQL_TYPE_TIME:
      TIME_from_longlong_time_packed(&ltime, packed_value);
      return time2my_decimal(&ltime, dec);
    case MYSQL_TYPE_DATE:
      TIME_from_longlong_date_packed(&ltime, packed_value);
      ulonglong2decimal(TIME_to_ulonglong_date(&ltime), dec);
      return dec;
    case MYSQL_TYPE_DATETIME:
    case MYSQL_TYPE_TIMESTAMP:
      TIME_from_longlong_datetime_packed(&ltime, packed_value);
      return date2my_decimal(&ltime, dec);
    default:
      DBUG_ASSERT(0);
      ulonglong2decimal(0, dec);
      return dec;
  }
}


/**