How to Export a List of All Your WordPress Post Titles and Publication Dates

Research Links

• YTvid; How to export a list of all your WordPress posts (using a simple SQL query in phpMyAdmin) – showed the Query which for some reason does not produce duplicates from the duplicates that result from revisions
• Exporting a list of all your WordPress posts (with publication dates) using SQL

This is a modified version of the query shown in the second link.  The result of this search yields only title and publication dates for purposes of organizing the website articles with Table of Contents

SELECT
    post_title,
    post_date
FROM
    wp_posts
WHERE
    post_type = 'post'
ORDER BY
    post_date