SQL Server 2016

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE ourtable
             (datecol1 datetime);
INSERT INTO ourtable
            (datecol1)
            VALUES ('2019-05-01'),
                   ('2019-05-02'),
                   ('1753-01-01'),
                   ('2019-05-04');
4 rows affected

SELECT replace(left(convert(varchar, datecol1, 120), 10), '1753-01-01', '')
       FROM ourtable;


(No column name)


2019-05-01

2019-05-02



2019-05-04