When converting a date/time field to text, you will get an ISO 8601 text string, not a date/time designed for humans to read. If you want a pretty date/time, use a formula function to convert it to text
DATETIME_FORMAT() for most conversions to text
DATESTR() for quick dates in YYYY-MM-DD format
TIMESTR() for quick times in HH:mm:ss format
I recommend using DATETIME_FORMAT() with SET_TIMEZONE() or the result will be in GMT time.
You can also set the language for months and days of the week by using SET_LOCALE().
Converting text and numbers to dates
Use DATETIME_PARSE() to convert text and numbers to dates.