Skip to content

获取当前日期、当前时间、当前年月日时分秒、当前时区、本地时间、本地时间戳

用 current_date 获取当前日期, 用 current_time 获取当前时间, 用 current_timestamp 获取当前年月日, 用 current_timezone 获取时区, 用 localtime 获取本地时间, 用 localtimestamp 获取本地时间戳, 用表格展示

SQL
|
select
  current_date as "当前日期",
  current_time as "当前时间",
  current_timestamp as "当前年月日",
  current_timezone() as "时区",
  localtime as "本地时间",
  localtimestamp as "本地时间戳"

SQL查询结果样例:

样例图片