grafana pod加时区:

    spec:
      containers:
        - env:
            - name: TZ
              value: Asia/Shanghai

grafana用户选cst时区:
Configuration - 》 preferences -》 Timezone ->

sql中时间字段用UNIX_TIMESTAMP处理下:

SELECT
  UNIX_TIMESTAMP(created_at) AS "time",
  today_ip_count AS "ip"
FROM baidu_report_infos
WHERE
  $__timeFilter(created_at) AND
  domain = "sre.ink"
ORDER BY created_at

发表回复

您的电子邮箱地址不会被公开。 必填项已用*标注

Captcha Code