Popular SQL Functions Missing in Domo

Reply
Highlighted
Yellow Belt

Popular SQL Functions Missing in Domo

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.


Accepted Solutions
Highlighted
Orange Belt

Re: Popular SQL Functions Missing in Domo

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.

 

 

 

View solution in original post


All Replies
Highlighted
Orange Belt

Re: Popular SQL Functions Missing in Domo

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.

 

 

 

View solution in original post

Highlighted
Orange Belt

Re: Popular SQL Functions Missing in Domo

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.

Highlighted
Yellow Belt

Re: Popular SQL Functions Missing in Domo

Perfect - thank you!

Announcements
Win free lodging at Domoapalooza! We want you to share you favorite Domo tips and tricks. Click here for more details!