'SQL Runner (Google Looker) change date format in query

This topic has been covered several times but I can't find a solution that applies to SQL Runner, which is the custom query portion of Google's Looker platform.

I am attempting to reformat a datetime SELECT statement from yyyy-mm-dd to mm-dd-yyyy.

Currently what I have is:

SELECT 
CAST(shift.datetime AS DATE)
FROM table.a

This gives me the yyyy-mm-dd result but so far my efforts to CONVERT have been fruitless. It does not appear that SQL Runner supports the CONVERT command or I am utilizing it incorrectly.

Any thoughts on this one?

Solution 1:^[1]

I believe sql runner is just gives us a way to directly access the db and it will not change any sql query while communicating with the db directly as long as the timezone of both explore as well as db matches.

Maybe something like this should work for your case

https://sql.tutorialink.com/convert-yyyymmdd-to-mm-dd-yyyy-in-snowflake/

lmk if the above works for your or not!

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	warlockJay

'SQL Runner (Google Looker) change date format in query

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]