URGENT: Unable to Insert/Restore Dates from Database

App Building
1

This is a high priority issue where dates times cannot be inserted/restored from the database correctly.
Steps to reproduce:

  1. Create a DATETIME column.
  2. Create a Retool DateTime picker.
  3. Create a SQL Builder query that takes the value of DateTime picker and inserts it into the DATETIME column.
  4. SQL Error.
    Times cannot restore from the database either.
    Steps to reproduce:
  5. Insert time into database manually.
  6. Set value from database to Retool DateTime picker default.
  7. Time is not restored.
    As it stands, it appears Retool’s date time pickers are broken. Please fix ASAP!
2

yes please. the SQL GUI is nice but if you are doing an insert with joins and other logic then we need to use the raw SQL

3