FROM_UNIXTIME not returning any results

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.

Find more posts tagged with

Comments

Tomo

Please try below.

BEAST MODE

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

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

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

RubenVisser

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,