Mysql DATE and DATETIME columns in Retool queries

Hey Church! This is relatively expected- All data types are cast into their Javascript counterparts inside of Retool, which doesn't have a type for a date without time. The closest would be casting it to a string and then anywhere you want to use that data in some JS logic you would need to parse it back into a Date.

The moment.js library is included inside of Retool, and can be helpful with this. When the time/timezone is unclear, {{ moment(INPUT) }} will create a new moment date object interpreted in the local timezone of the user, and {{ moment.utc(INPUT) }} will interpret it as being in UTC time as the source