This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I believe the approach outlined above should work for your purposes.
I do want to note that by formatting the data in this manner, you are converting the data to a STRING rather than a DATETIME value. As a result, you won't be able to use the new value for datetime functions (datetimeadd, datetimediff, etc.). If you do need to perform calculations with these values, you'll need to use the original field.