title: Getting Month from date field - KDB
body: <p>I have sales data stored in a database. The sales_date field contains the date on which the sale took place. I want to extract this data grouped by month, so that I will get the aggregate data for Jan, Feb, etc. Is there a way I can do this without having to extract the entire data and then doing it manually? </p>