Mysql Flow - DATE_FORMAT not working.

mc1392
mc1392
in Magic ETL

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?

Comments

  • AS
    AS Coach

    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?

    Aaron
    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"

Categories