Select first day of month in presto

Question

I'm trying to select the first day of the month for a date value in Presto (Hive Table). I've tried TRUNC(date,'MM') which works in Hive but not Presto.

Answer 1

Use date_trunc('month', date_value)

presto> select date_trunc('month', DATE '2018-05-24');
   _col0
------------
 2018-05-01
(1 row)