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 |