grafana mysql 数据源时差8小时问题
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