diff --git a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataAnalysisMapper.xml b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataAnalysisMapper.xml
index 3bcf6d7..bb1a5cb 100644
--- a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataAnalysisMapper.xml
+++ b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataAnalysisMapper.xml
@@ -189,7 +189,7 @@
         DATE_FORMAT(UPTIME,'%Y-%m-%d %H:%i:%S')
     </sql>
     <sql id="upTime_toChar" databaseId="pgsql">
-        to_timestamp(UPTIME,'%Y-%m-%d %H:%i:%s')
+        to_char(UPTIME,'%Y-%m-%d %H:%i:%s')
     </sql>
     <sql id="upTime_toChar" databaseId="oracle">
         to_char(UPTIME,'yyyy-mm-dd hh24:mi:ss')
@@ -252,14 +252,14 @@
         TO_DATE(#{beginTime},'yyyy-mm-dd hh24:mi:ss')
     </sql>
     <sql id="begintime_sql" databaseId="pgsql">
-        to_timestamp(#{beginTime},'%Y-%m-%d %H:%i:%s')
+        to_char(#{beginTime},'%Y-%m-%d %H:%i:%s')
     </sql>
 
     <sql id="endtime_sql" databaseId="oracle">
         TO_DATE(#{endTime},'yyyy-mm-dd hh24:mi:ss')
     </sql>
     <sql id="endtime_sql" databaseId="pgsql">
-        to_timestamp(#{endTime},'%Y-%m-%d %H:%i:%s')
+        to_char(#{endTime},'%Y-%m-%d %H:%i:%s')
     </sql>
     <sql id="endtime_sql" databaseId="mysql">
         #{endTime}
@@ -536,7 +536,7 @@
         DATE_FORMAT(LOGTIME,'%Y-%m-%d %H:%i:%S')
     </sql>
     <sql id="logTime_toChar" databaseId="pgsql">
-        to_timestamp(LOGTIME,'%Y-%m-%d %H:%i:%s')
+        to_char(LOGTIME,'%Y-%m-%d %H:%i:%s')
     </sql>
     <sql id="logTime_toChar" databaseId="oracle">
         to_char(LOGTIME,'yyyy-mm-dd hh24:mi:ss')

diff --git a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataAnalysisMapper.xml b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataAnalysisMapper.xml
index 3bcf6d7..bb1a5cb 100644
--- a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataAnalysisMapper.xml
+++ b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataAnalysisMapper.xml
@@ -189,7 +189,7 @@
         DATE_FORMAT(UPTIME,'%Y-%m-%d %H:%i:%S')
     </sql>
     <sql id="upTime_toChar" databaseId="pgsql">
-        to_timestamp(UPTIME,'%Y-%m-%d %H:%i:%s')
+        to_char(UPTIME,'%Y-%m-%d %H:%i:%s')
     </sql>
     <sql id="upTime_toChar" databaseId="oracle">
         to_char(UPTIME,'yyyy-mm-dd hh24:mi:ss')
@@ -252,14 +252,14 @@
         TO_DATE(#{beginTime},'yyyy-mm-dd hh24:mi:ss')
     </sql>
     <sql id="begintime_sql" databaseId="pgsql">
-        to_timestamp(#{beginTime},'%Y-%m-%d %H:%i:%s')
+        to_char(#{beginTime},'%Y-%m-%d %H:%i:%s')
     </sql>
 
     <sql id="endtime_sql" databaseId="oracle">
         TO_DATE(#{endTime},'yyyy-mm-dd hh24:mi:ss')
     </sql>
     <sql id="endtime_sql" databaseId="pgsql">
-        to_timestamp(#{endTime},'%Y-%m-%d %H:%i:%s')
+        to_char(#{endTime},'%Y-%m-%d %H:%i:%s')
     </sql>
     <sql id="endtime_sql" databaseId="mysql">
         #{endTime}
@@ -536,7 +536,7 @@
         DATE_FORMAT(LOGTIME,'%Y-%m-%d %H:%i:%S')
     </sql>
     <sql id="logTime_toChar" databaseId="pgsql">
-        to_timestamp(LOGTIME,'%Y-%m-%d %H:%i:%s')
+        to_char(LOGTIME,'%Y-%m-%d %H:%i:%s')
     </sql>
     <sql id="logTime_toChar" databaseId="oracle">
         to_char(LOGTIME,'yyyy-mm-dd hh24:mi:ss')
diff --git a/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceMapper.xml b/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceMapper.xml
index ca4e201..d5eb485 100644
--- a/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceMapper.xml
+++ b/casic-device/src/main/java/com/casic/missiles/modular/system/dao/mapping/DeviceMapper.xml
@@ -28,7 +28,7 @@
             (INSTALLDATE,'yyyy-MM-dd')
     </sql>
     <sql id="installdate_toChar" databaseId="pgsql">
-        to_timestamp (INSTALLDATE,'%Y-%m-%d %H:%i:%s')
+        to_char (INSTALLDATE,'%Y-%m-%d %H:%i:%s')
     </sql>
     <!-- 通用查询结果列 -->
     <sql id="Base_Column_List">
@@ -108,7 +108,7 @@
         to_char(LOGTIME,'yyyy-mm-dd hh24:mi:ss')
     </sql>
     <sql id="logTime_toChar" databaseId="pgsql">
-        to_timestamp(LOGTIME,'%Y-%m-%d %H:%i:%s')
+        to_char(LOGTIME,'%Y-%m-%d %H:%i:%s')
     </sql>
 
     <sql id="upTime_toChar" databaseId="mysql">
@@ -119,7 +119,7 @@
         to_char(UPTIME,'yyyy-mm-dd hh24:mi:ss')
     </sql>
     <sql id="upTime_toChar" databaseId="pgsql">
-        to_timestamp(UPTIME,'%Y-%m-%d %H:%i:%s')
+        to_char(UPTIME,'%Y-%m-%d %H:%i:%s')
     </sql>
 
     <sql id="keywords_sql" databaseId="oracle">
@@ -145,10 +145,10 @@
         #{beginTime}
     </sql>
     <sql id="begintime_sql" databaseId="pgsql">
-        to_timestamp(#{beginTime},'%Y-%m-%d %H:%i:%s')
+        to_char(#{beginTime},'%Y-%m-%d %H:%i:%s')
     </sql>
     <sql id="endtime_sql" databaseId="pgsql">
-         to_timestamp(#{endTime},'%Y-%m-%d %H:%i:%s')
+        to_char(#{endTime},'%Y-%m-%d %H:%i:%s')
     </sql>
     <select id="getDeviceList" resultType="com.casic.missiles.modular.system.dto.DeviceInfoDto">
         SELECT id,