Data in Query Editor, but blank in Table

I have an date/time appointment field that I split by delimiter (space) into separate date and time fields in the query editor (image 1). However, once the data loads into the table, the Time field i...