I am using freeradius with mysql.
Thousands of users account expiration is stored in radcheck table. Expiration value is as follows
29 Jul 2018 12:00:00 30 Jul 2018 12:00:00
I want to change only 12:00:00 to 00:00:00 (means date remains same for each user but time should change to 00:00:00)
so that it will look alike
29 Jul 2018 00:00:00 30 Jul 2018 00:00:00
Regards, J
<http:///> - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Ok I got it. UPDATE radcheck SET value = replace(value, '12:00:00', '00:00:00') WHERE attribute = 'Expiration'; thank you. ________________________________ From: Freeradius-Users <freeradius-users-bounces+aacable=hotmail.com@lists.freeradius.org> on behalf of Uchenna Nebedum <nebeduch@gmail.com> Sent: Sunday, July 1, 2018 10:58 PM To: FreeRadius users mailing list Subject: Re: mysql change time in radcheck table What does your insertion into the radcheck table?. from what i understand, you need to do a MySQL Update statement or something. On Sun, Jul 1, 2018, 18:34 JAHANZAIB SYED <aacable@hotmail.com> wrote: - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html