Skip to content

    • Archive

    Archive

    FROM_UNIXTIME not returning any results

    Member
    in Archive

    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.  

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Comments

    • Contributor

      Please try below.

       

      BEAST MODE

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

       

    • Member

      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

    • Contributor

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

    • Member

      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,

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories