日期和时间数据类型
在 PostgreSQL 中使用函数处理数据
Brian Piccolo
Sr. Director, Digital Strategy
TIMESTAMP 数据类型
- ISO 8601 格式：yyyy-mm-dd
+------------------------------+ | timestamp | |------------------------------| | 2019-03-26 01:05:17.93027+00 | +------------------------------+
SELECT payment_date
FROM payment;
+---------------------+
| payment_date |
|---------------------|
| 2005-05-25 11:30:37 |
+---------------------+
DATE 与 TIME 数据类型
+------------+-------------------+
| date | time |
|------------|-------------------|
| 2005-05-28 | 01:05:17.93027+00 |
+------------+-------------------+
SELECT create_date
FROM customer
+-------------+
| create_date |
|-------------|
| 2006-02-14 |
+-------------+
INTERVAL 数据类型
+-----------+
| interval |
|-----------|
| 4 days |
+-----------+
SELECT rental_date + INTERVAL '3 days' as expected_return
FROM rental;
+---------------------+
| expected_return |
|---------------------|
| 2005-05-27 22:53:30 |
+---------------------+
查看日期和时间类型
SELECT
column_name,
data_type
FROM INFORMATION_SCHEMA.COLUMNS
WHERE column_name in ('rental_date')
AND table_name ='rental';
+-------------+-----------------------------+
| column_name | data_type |
|-------------|-----------------------------|
| rental_date | timestamp without time zone |
+-------------+-----------------------------+
让我们来练习！
在 PostgreSQL 中使用函数处理数据
