I am attempting to remove a time stamp in the middle of a date with no success. If I change it from a string to a date it will just output NULL. Tried a Timeparse with no luck. Any suggestions? Thank you.
Would like it to match the column on the left. yyyy-mm-dd