SQL lab shows invalid date for Started column in Query History

[mdeshmu]

A clear and concise description of what the bug is.

How to reproduce the bug

1. Go to 'SQL Lab' and run a query
2. Click on the 'Query History' tab
3. Look at the values of to 'Started' column
4. See the "Invalid date" written

Expected results

proper time should be shown as per the current code

Actual results

"invalid date" is shown

Screenshots

Environment

(please complete the following information):

• browser type and version: Chrome and Mozilla
• superset version: 3.0.0.rc1
• python version: 3.9.x
• node.js version: NA
• any feature flags active: NA

Checklist

Make sure to follow these steps before submitting your issue - thank you!

• I have checked the superset logs for Python stack traces and included them here as text if there are any.
• I have reproduced the issue with at least the latest released version of the superset.
• I have checked the issue tracker for the same issue and haven't found one similar.

Additional context

NA

[mdeshmu]

The current code only shows time which is not useful if we want to see queries more than a day old.
While fixing this, request to add the date as well in the output.

[michael-s-molina]

@justinpark Could you take a look at this?

[justinpark]

@mdeshmu could you test with latest 3.0? I don't see the same problem with the latest 3.0

[justinpark]

@mdeshmu could you share the startDttm value in your bootstrap data by

const appContainer = document.getElementById('app');
const dataBootstrap = appContainer?.getAttribute('data-bootstrap');
JSON.parse(dataBootstrap)

[zhaorui2022]

I also run into this issue and I am on 3.0.0rc3. however, when trying to inspect the bootstrap data, it seems the structure is different than the one in the screenshot above.

And for our case, it is only happening to the successful queries, not the failed ones.