Dear Experts
Pleass help to conver the below date format to as mentioned.
SELECT FORMAT(DATEADD(dd, 0, '2021-04-02 18:54:13.4966667'), 'HHmmss')
Desired result is 185413
I am getting error like
conversion failed when converting date and/or time from character string.
Please help