🐞 bug: Pitr show backup information start_time and end_time is not in date format.

[peilinqian]

Environment

• Contents of your values.yaml file,if your helm deployment process goes wrong.
• Contents of your CRD resource file. Include proxy.shardingsphere.apache.org/v1alpha1 and proxyconfig.shardingsphere.apache.org/v1alpha1
• Kubernetes distro (e.g. RKE/K3s/EKS/OpenShift) and version

Issue description

• Which phase is not functioning properly, is it the installation phase or the apply CRD phase ?

Pitr show backup information start_time and end_time is not in date format.

[peilq_og@openGauss54 ~]$ ./gs_pitr show
[{
        "info": {
                "id": "45d3c37d-2fce-4cd5-9851-88c0906e7d60",
                "csn": "44696",
                "backup_mode": "FULL",
                "start_time": 1700037790,
                "end_time": 1700037837
        },
        "dn_list": [
                {
                        "ip": "20.20.20.54",
                        "port": 18000,
                        "status": "Completed",
                        "backup_id": "S45PK0",
                        "start_time": 1700037792,
                        "end_time": 1700037814
                },
                {
                        "ip": "20.20.20.56",
                        "port": 18000,
                        "status": "Completed",
                        "backup_id": "S45PK0",
                        "start_time": 1700037792,
                        "end_time": 1700037836
                }
        ],
        "ss_backup": {
                "status": "Completed",
                "cluster_info": {
                        "meta_data": {
                                "databases": {
                                        "sharding_db": "databaseName: sharding_db\ndataSources:\n  ds_0:\n    password: Test@123\n    dataSourceClassName: null\n    url: jdbc:opengauss://20.20.20.54:18000/test?stringtype=unspecified\u0026bitToString=true\u0026blobMode=off\n    username: test\n    minPoolSize: 1\n    maxPoolSize: 10\n  ds_1:\n    password: Test@123\n    dataSourceClassName: null\n    url: jdbc:opengauss://20.20.20.56:18000/test?stringtype=unspecified\u0026bitToString=true\u0026blobMode=off\n    username: test\n    minPoolSize: 1\n    maxPoolSize: 10\nrules:\n- !SHARDING\n  autoTables:\n    t_order:\n      actualDataSources: ds_0,ds_1\n      keyGenerateStrategy:\n        column: id\n        keyGeneratorName: snowflake\n      logicTable: t_order\n      shardingStrategy:\n        standard:\n          shardingAlgorithmName: auto_mod\n          shardingColumn: id\n    t_sales:\n      actualDataSources: ds_0,ds_1\n      keyGenerateStrategy:\n        column: id\n        keyGeneratorName: snowflake\n      logicTable: t_sales\n      shardingStrategy:\n        standard:\n          shardingAlgorithmName: auto_mod\n          shardingColumn: id\n    t_user:\n      actualDataSources: ds_0,ds_1\n      logicTable: t_user\n      shardingStrategy:\n        standard:\n          shardingAlgorithmName: t_user_hash_mod\n          shardingColumn: user_id\n  keyGenerators:\n    snowflake:\n      type: SNOWFLAKE\n  shardingAlgorithms:\n    auto_mod:\n      props:\n        sharding-count: 2\n      type: MOD\n    t_user_hash_mod:\n      props:\n        sharding-count: '4'\n      type: hash_mod\n"
                                },
                                "props": "props:\n  check-table-metadata-enabled: false\n  max-connections-size-per-query: 1\n  sql-show: true\n  cdc-server-port: 33071\n  proxy-netty-backlog: 1024\n  proxy-default-port: 3307\n  proxy-frontend-database-protocol-type: openGauss\n  kernel-executor-size: 16\n  proxy-backend-query-fetch-size: -1\n  proxy-frontend-max-connections: 0\n  system-log-level: INFO\n  proxy-frontend-ssl-version: TLSv1.2,TLSv1.3\n  proxy-frontend-ssl-enabled: false\n  proxy-frontend-flush-threshold: 128\n  proxy-frontend-executor-size: 0\n",
                                "rules": "rules:\n- !AUTHORITY\n  privilege:\n    type: ALL_PERMITTED\n  users:\n  - password: root\n    user: root@%\n  - password: Proxy@123\n    user: proxy@%\n- !TRANSACTION\n  defaultType: XA\n  providerType: Narayana\n- !SQL_PARSER\n  parseTreeCache:\n    initialCapacity: 128\n    maximumSize: 1024\n  sqlCommentParseEnabled: false\n  sqlStatementCache:\n    initialCapacity: 2000\n    maximumSize: 65535\n- !TRAFFIC {}\n- !SQL_TRANSLATOR\n  useOriginalSQLWhenTranslatingFailed: true\n- !SQL_FEDERATION\n  executionPlanCache:\n    initialCapacity: 2000\n    maximumSize: 65535\n  sqlFederationEnabled: false\n- !GLOBAL_CLOCK\n  enabled: true\n  props:\n    port: 6379\n    host: 127.0.0.1\n  provider: redis\n  type: TSO\n- !LOGGING\n  loggers:\n  - additivity: true\n    level: INFO\n    loggerName: ShardingSphere-SQL\n    props:\n      enable: true\n"
                        },
                        "snapshot_info": {
                                "csn": "44696",
                                "create_time": "2023-11-15 16:43:10"
                        }
                },
                "storage_nodes": [
                        {
                                "ip": "20.20.20.54",
                                "port": "18000",
                                "username": "test",
                                "password": "Test@123",
                                "database": "test"
                        },
                        {
                                "ip": "20.20.20.56",
                                "port": "18000",
                                "username": "test",
                                "password": "Test@123",
                                "database": "test"
                        }
                ]
        }

Error log

• Including ShardingSphere-Proxy error log and ShardingSphere-Operator error log

Expected result

Pitr show backup information start_time and end_time is in date format.