pears.SetNulLogoffTimes

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Original SQL

CREATE EVENT "pears"."SetNulLogoffTimes" TYPE "DatabaseStart"  ENABLE 
HANDLER
BEGIN
  UPDATE "DatabaseLoginAttempts" SET "LogOffTime" = "lesser"("dateadd"("minute",-1,CURRENT TIMESTAMP),CAST("dateadd"("day",1,"date"("loginattempttime")) AS TIMESTAMP))
    WHERE "LogOffTime" IS NULL
END