Max function issue for date

[TrifactaUsers]

I see an issue with Max function for the date. 

example max(2018-05-31) is returning value as 1527724800000 ? is it a bug? 

[Trifacta_Alumni · Accepted 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

[TrifactaUsers]

Thank you..

[47d68003bfbc2bffa736]

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')