FROM_UNIXTIME not returning any results

Swoopy
Swoopy
in Dataflows

Just looking for a simple beast mode to convert Unix timestamps into date format. 

 

FROM_UNIXTIME(`FieldName`,'%m,%d,%y')

 

This doesn't return any data despite being a valid formula. Everything I've found on the straight SQL function says this is correct and should yield a date. What am I missing?

 

Thanks.  

Comments

  • Tomo
    Tomo 🟢

    Please try below.

     

    BEAST MODE

    DATE_FORMAT(FROM_UNIXTIME(`FieldName`),'%m,%d,%y')

     

  • Swoopy
    Swoopy

    Thanks @Tomo, that get's me about half way there. It delivers the month and day, but the year is still off. Take a look at the shot below, now it's giving a 5 digit number for year.  

     

    Screen Shot 2017-03-07 at 12.39.05 PM.png

  • Tomo
    Tomo 🟢

    Is a column of BEAST MODE being used for an X axis?

  • user09453
    user09453

    Hi all, 

    I combined some information that I found and this works perfect if you want to use Beast Mode to convert a UNIX timestamp into a date (if needed you can add %H:%i:%s to get time). If you do it like this then you can use that newly created value on the x-axis.

    STR_TO_DATE(DATE_FORMAT(FROM_UNIXTIME(`field_name`),'%Y %m %d'),'%Y %m %d')

    All the best,

Categories