The example output is what Fehily describes as "Standard" SQL. He makes a point to add notations at the end of examples in his text where a listing/query would need to be updated based on DBMS, (+ to concatenate with MS Access versus || for Oracle).
The output from Manifold is completely correct, and reflects the datetime values in the [pubdate] column.
I'm curious if there is a way to reformat the text output by the CAST function so that the concatenated string matches the "Standard" output the Fehily has published.
If I was doing this for a large/persistent project (instead of an exercise), I would probably look at automating a way to export the datetime values to Excel or Access, change them to my desired format and link them back as a text string, thus side-stepping the CAST function.