Having a hard time using a column as Date. Its currently in MM/DD/YYYY HH:MM format and I am struggling to convert/cast into date format. Here is the format below.
11/04/2021 12:00
I am able to convert the varchar into char but am not able to use as a date. Any suggestion would be great.
CodePudding user response:
Check out if this helps
select convert(char(10), getdate(), 101)
' ' convert(char(5), getdate(), 108);
Thanks!