def iso_string_to_sql_date_sqlite(x: str) -> str:
    """
    Provides SQLite SQL to convert a column to a ``DATE``, just by taking the
    date fields (without any timezone conversion). The argument ``x`` is the
    SQL expression to be converted (such as a column name).
    """
    return f"DATE(SUBSTR({x}, 1, 10))"