def get_dates(df, date_column):
    """Converts a given date to various formats and returns an updated dataframe.

    Args:
        df: Pandas dataframe.
        columns: List of columns to transform.

    Returns:
        Original dataframe with additional date columns.
    """
    df['day'] = df[date_column].dt.strftime('%d')
    df['month'] = df[date_column].dt.strftime('%m')
    df['year'] = df[date_column].dt.strftime('%Y')
    df['year_month'] = df[date_column].dt.strftime('%Y%m')
    df['week_number'] = df[date_column].dt.strftime('%U')
    df['day_number'] = df[date_column].dt.strftime('%j')
    df['day_name'] = df[date_column].dt.strftime('%A')
    df['month_name'] = df[date_column].dt.strftime('%B')
    df['mysql_date'] = df[date_column].dt.strftime('%Y-%d-%m')
    return df
