<div dir="ltr"><span style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px">Hi,everyone,</span><br style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px"><span style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px">Following is my logback.xml about implement DBAppender just to storage the log message to mysql database.</span><br style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px"><span style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px"> <appender name="DB" class="ch.qos.logback.classic.db.DBAppender"></span><br style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px"><span style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px">      <connectionSource class="ch.qos.logback.core.db.DriverManagerConnectionSource"></span><br style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px"><span style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px">          <driverClass>com.mysql.jdbc.Driver</driverClass></span><br style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px"><span style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px">          <url>jdbc:MySQL://<a href="http://127.0.0.1:3306/EventDataBase">127.0.0.1:3306/EventDataBase</a></url></span><br style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px"><span style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px">          <user>root</user></span><br style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px"><span style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px">          <password>root</password></span><br style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px"><span style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px">      </connectionSource></span><br style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px"><span style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px">  </appender></span><br style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px"><br style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px"><span style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px">then: The following is the result ,the log message was storage in the mysql database,but the "timestmp" filed in the table named logging_event ,the timestmp's pattern is not as{HH:mm:ss.SSS} just as the consoleAppender,can I transform it's pattern to {HH:mm:ss:SSS} ? Could you please give me some help?I have tried add <encoder> <pattern>%d</span><span class="" style="line-height:22.4px;color:rgb(0,0,0);font-family:Simsun;font-size:14px">{HH:mm:ss.SSS}</span><span class="" style="line-height:22.4px;color:rgb(0,0,0);font-family:Simsun;font-size:14px"> </span><span style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px"></pattern></encoder> as the ConsoleAppender's logback.xml,but I failed.</span><br style="color:rgb(0,0,0);font-family:Simsun;font-size:14px;line-height:21px"><img src="https://mail.bjut.edu.cn/?q=compose.output&action=mail.attach&aid=20715&mid=919&part=1.2&method=show" style="color: rgb(0, 0, 0); font-family: Simsun; font-size: 14px; line-height: 21px;"></div>