Security

I am looking to add an additional attribute to the Time Source in ClearPass.  I would like to have an attribute for 12 months to use for the MAC-Auth Expiry for guest registrations.  When I try to add the 12 month attribute following the same pattern as the 6 month attribute I get a SQL error.  

Does anyone have the correct syntax to add the attribute for 12 months?

Always create a custom filter. Don't add to the existing one.

SELECT date_trunc('hour', localtimestamp(0)+ interval '365 days') as one_year

Thanks so much for that, it worked like a charm!!