FROM_UNIXTIME not returning any results

Swoopy

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.  

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.  

 

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,