How to declare month to be within current_month only in presto?

@dana 

You can declare a variable for the current month in Presto using the DATE_TRUNC function. Here's an example query that declares a variable current_month to be within the current month:

1

SELECT DATE_TRUNC('month', current_date()) as current_month

This query will truncate the current date to the beginning of the current month, giving you a date that represents the start of the current month. You can then use this variable in your queries to filter data for the current month only.