Storing Last Login Plugin value in SQL
dovecot at ptld.com
dovecot at ptld.com
Mon Sep 13 21:12:21 EEST 2021
The last-login plugin sends a number (epoch seconds) as uint or string
in a query to sql. If i create a column type in sql of varchar() the
number is saved in the column as a string, but not very useful.
I can not figure out how to get that value into a date/time column such
as date, datetime or timestamp. All three cause an error of Incorrect
datetime value: '1631556506' for column.
Anyone have any idea how to get the last-login plugin to update a
date/time column in sql?
More information about the dovecot
mailing list