Unable to import date/time values

[seancolsen]

Steps to reproduce

1. From the Schema Page, choose "New Table" > "From Data Import"

2. Select "Copy and Paste Text"

3. Paste the following and proceed:

   date
   2000-01-01 12:00:00
   

4. Expect to see a preview of your data to be imported.

5. Instead, observe the error:

   Unable to tabulate data

   

Notes

• I've tried the following date/time formats, all with the same error:

  • (A): 2000-01-01 12:00:00
  • (B): 2000-01-01T12:00:00
  • (C): 2000-01-01T12:00:00.0Z AD
  • (D): 2000-01-01T12:00
  • (E): 01/01/2000 12:00 pm
  • (F): 01/01/2000 12:00

  Note that format (C) is what Mathesar uses when exporting from a Date & Time column. That would seem to demonstrate that users cannot import what they export, which seems especially problematic. to me.

[seancolsen]

@mathemancer or @Anish9901 I'd like one of you to look at this and determine whether it's suitable for community contributors (and apply the necessary labels if so).