Incorrect datetime issue

Alan DeKok aland at
Thu Sep 13 13:46:44 CEST 2018

On Sep 13, 2018, at 7:34 AM, Somanath Mishra <somanath.mishra at> wrote:
> Hi,
> i am facing issue in radacct insert. So it is showing incorrect dattime.
> So in debug i found datetime cloumn is missing  'FROM_UNIXTIME' in debug
> o/p . Below you can see debug msg.
> ...
> ----------------------------------------------------------------------
> but in insert stmt query looking ok. below is insert stmt query.

  The query from the debug output is not the same one as the query you posted here.

  The SQL configuration contains many, many, queries.  The debug output is likely showing you a different one.

  i.e. the debug output includes "strftime".  But the query you posted here doesn't use that.  So they are different queries.

  You need to find the *correct* query in the config files and fix that.

  It looks like you're using the sqlite driver for SQL.  Is this what you want to do?

  Alan DeKok.

More information about the Freeradius-Users mailing list