날짜·시간 데이터 타입
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에서 데이터 조작을 위한 함수
