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!!
At Aruba, we believe that the most dynamic customer experiences happen at the Edge. Our mission is to deliver innovative solutions that harness data at the Edge to drive powerful business outcomes.
© Copyright 2020 Hewlett Packard Enterprise Development LPAll Rights Reserved.