I have field with date format that I need to move to another table that is in a fixed all char layout. I thought this would be straight forward but seems to be eluding me. Source is YYYY-MM-DD and I want to end up with YYYYMMDD text. Thank you for what should be simple.
If the field you're selecting is a DATE field, then something like: SELECT CONVERT(VARCHAR(8), MyDateField, 112) FROM MyTable might be the way to go. See [`CONVERT`] documentation for the various date format parameter options :