Is there a function in the Quicksight Custom SQL query window that will allow me to drop the time portion from my datetime. My format is currently: yyyy-MM-dd HH:mm:ss.SSS and I would like my format to be * yyyy-MM-dd 00:00:00.000. I need the transformation to be done in my underlying table pulled from Timestream so that it can be joined with my other table whos source is Athena, with the date format of yyyy-MM-dd 00:00:00.000.
Custom SQL uses the databse query language of your source. You should look for functions in this database that can format the date, e.g. if you are using Amazon TimeStream you can find the functions to parse dates here
Same thing with Athena
Hope this helps.
The data source im using is timestream, but the timestream date/time functions return errors. What can I do to fix this?