You can use functions like the month(), year(), day() weekday() functions to derive the different levels which you need.
An example of how this can be done:
Month("Send Date") as Month,
Year("Send Date") as Year,
Hour("Send Date") as Hour
If needed you may need to format the date first using the date function and focusing on the second parameter.
For example Date("Send Date", 'DD/MM/YYYY hh:mm:ss') as "Send Date"
I hope this helps. Please can I ask you to mark this as helpful and answered if this does help.