Re: How to get current datetime in freeradius?

2 Oct 2019

      Hi Houman,

"%l" gives you POSIX time (seconds since the Unix epoch). You should be able to modify your query like this to make it work (make sure to test it, it's just off the top of my head):

%{sql:SELECT UNIX_TIMESTAMP(expires_at) FROM main_db.`user` WHERE main_db.`user`.username ='%{User-Name}'}

UNIX_TIMESTAMP should convert the date to POSIX time in seconds (unsigned integer).

Kind regards,
Christian Strauf