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?

Comments

  • 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?