Dear Experts
Please help to convert the below data and time format as given below
Date_col
2021-04-02 14:33:18.1166667
2021-04-05 18:47:21.9200000
2021-04-03 10:54:36.5333333
2021-04-03 21:25:21.8166667
SELECT FORMAT(TRY_CONVERT (DATETIME, DATE_COL, 103), 'yyMMdd') from shipping_tb;
I am getting null value here instead i need to get result as below
210402
210405
210403
210403
Please help
