July 2023
Intermediate to advanced
278 pages
5h 40m
Chinese
Content preview from Trino 权威指南：原书第2版
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
150
|
第
8
章
表 8-11：可解析为日期数据类型的字符串格式
DATE
YYYY-MM-DD
当打印
TIMESTAMP
、
TIMESTAMP WITH TIMEZONE
、
TIME
、
TIME WITH TIMEZONE
或
DATE
的输出时，
Trino
使用表
8-12
中的输出格式。如果你想以严格的
ISO 8601
格式输出，可
以使用
to_iso8601
函数。
表 8-12：时间输出格式
数据类型 格式
TIMESTAMP yyyy-MM-dd HH:mm:ss.SSS ZZZ
TIMESTAMP WITH TIMEZONE yyyy-MM-dd HH:mm:ss.SSS ZZZ
TIME yyyy-MM-dd HH:mm:ss.SSS ZZZ
TIME WITH TIMEZONE yyyy-MM-dd HH:mm:ss.SSS ZZZ
DATE YYYY-MM-DD
时区
时区添加了额外的重要信息。
Trino
支持
TIME WITH TIMEZONE
，但通常最好使用包含时
区的
DATE
或
TIMESTAMP
类型，这样可以用
DATE
格式计算夏令时。时区必须表示为数值
型
UTC
偏移值。以下是一些时区字符串的示例：
• +08:00
•
-
10:00
让我们来看一些例子：
SELECT TIME '02:56:15' AS utc;
utc
---------
02:56:15
(1 row)
SELECT TIME '02:56:15' AT TIME ZONE '+08:00' AS perth_time; ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.