Mysql Flow - DATE_FORMAT not working.


I am attempting to format a java long date string in DOMO using:

DATE_FORMAT(`createdDate`,'%m %d %Y')

Here is a sample date string: 1549477680843


I see there are a few mysql functions not available in DOMO.


Can anyone confirm this?


  • AS

    DATE_FORMAT will take a date and alter the format it appears in, but it won't take a string and make it a date.  You'll need a different approach.

    What does your string represent?  Milliseconds since a certain date?

    MajorDomo @ Merit Medical

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"