itsautfullday commented on issue #11660: URL: https://github.com/apache/druid/issues/11660#issuecomment-1824251695
> I just discovered the following syntax that works for converting varchar to timestamps for sys tables. > > ``` > select cast(REPLACE(created_time,'T',' ') as TIMESTAMP) from sys.tasks limit 10 > ``` THE LEGEND! Was looking for this today in the morning and couldn't find anything and then in the afternoon found this answer. Totally worked! Thanks! -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
