In Airtable the DateTime Data is correct but if you upload it in the Big Query, it will transform into a Decimal String Style of Numbers. See the table below:
| Date | True Date |
|---|---|
| 44493.61666667 | 2021-10-24T14:48:00 |
| 44522.775 | 2021-11-22T18:36:00 |
| 44493.67916666667 | 2021-10-24T16:18:00 |
| 44522.739583333336 | 2021-11-22T17:45:00 |
This is the problem I have encountered. Assuming the table name is Airtable. Can you give a suggested query to convert it into the correct and true timestamp?
Actually, I post it also 