Hi

The statement below does not throw ParseException when going through SQLServerStatementParser:

select
            TOP 10
            *
        from (
            select
                DISTINCT
                DATE_FORMAT( col1, '%Y%m%d' ) AS col1
            from table1
        ) xx