It should be easy to change a varchar to a date or a char to a number using the cast command; avoiding the need to create a view for just a single field format.
Can you please implement the CAST() function
It should be easy to change a varchar to a date or a char to a number using the cast command; avoiding the need to create a view for just a single field format.
Can you please implement the CAST() function
Hi @PhilBailey
It’s a bit more complicated, since the Custom Expression options are not equivalent to your database functions, and Metabase works with 15+ different database types, which each have their own functions.
There’s a few open requests - upvote by clicking on the first post of each issue
https://github.com/metabase/metabase/issues/11330
https://github.com/metabase/metabase/issues/12938
https://github.com/metabase/metabase/issues/14054