mysql change time in radcheck table

[JAHANZAIB SYED]

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 at lists.freeradius.org> on behalf of Uchenna Nebedum <nebeduch at 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 at hotmail.com> wrote:

> 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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html