Popular SQL Functions Missing in Domo

user019875

Domo,

I saw a post from 5 years ago stating that SQL didn't have CAST or CONVERT. It's now 2020 and:

CAST doesn't even show up in the prompts
CONVERT does but doesn't work
ROUND is not even considered in the prompts.

Please add these and other popular functions ASAP. It's painful these are not in there...Thank you.

Find more posts tagged with

Accepted answers

MichelleH

These functions will actually still work even though they aren't auto-suggested. See the attached screenshot of a preview in a MySQL dataflow. The same will also work in Redshift.

Domo SQL Functions.PNG

All comments

MichelleH

These functions will actually still work even though they aren't auto-suggested. See the attached screenshot of a preview in a MySQL dataflow. The same will also work in Redshift.

Domo SQL Functions.PNG

bdavis

Incase this helps anyone coming to this thread, as of 2/5/2020 the version of MySQL in Domo appears to be: 5.6.28-76.1-56

Current version of MySQL available to public: 8.0.19

This way you can check what functions may or may not be available.

user019875

Perfect - thank you!