I see an issue with Max function for the date.
example max(2018-05-31) is returning value as 1527724800000 ? is it a bug?
Solved! Go to Solution.
Hi Sridar,
When a calculation like Max, Min, Avg, etc. is done on a date, Trifacta converts the date to Unixtime. To convert this date back to yyyy-MM-dd, use Unixtimeformat and specify the date format you would like to convert to.
Hope this helps!
David
Thank you..
Remember that the date format is case sensitive, that is, MM refers to month and mm refers to minute. For the complete time stamp, use something like this:
unixtimeformat(my_date, 'yyyy-MM-dd HH:mm:ss')