Presto SQL: TO_UNIXTIME
you need to cast the string '2018-08-24 06:42:16' to one of the allowed types

TO_UNIXTIME(cast ('2018-08-24 06:42:16' as timestamp) ) new_year_ut


or

TO_UNIXTIME( timestamp '2018-08-24 06:42:16' )