Hello, we have a table and two of the columns are inpdate and inptime. Inpdate is of type datetime2, inptime is of type time.
I know that I can CONVERT (VARCHAR, inpdate, 112) to turn 3rd August 2022 into 20220803.....is there an equivalent for time? I'd like 18:47:23 to be returned as 184723.
Thanks!