Types de données de date et d'heure

Fonctions permettant de manipuler les données dans PostgreSQL

Brian Piccolo

Sr. Director, Digital Strategy

Types de données TIMESTAMP

Format ISO 8601 : aaaa-mm-jj

+------------------------------+
| timestamp                    |
|------------------------------|
| 2019-03-26 01:05:17.93027+00 |
+------------------------------+

----CODE_GLUE----


SELECT payment_date
FROM payment;

+---------------------+
| payment_date        |
|---------------------|
| 2005-05-25 11:30:37 |
+---------------------+

Types de données DATE et TIME

+------------+-------------------+
| date       | time              |
|------------|-------------------|
| 2005-05-28 | 01:05:17.93027+00 |
+------------+-------------------+


SELECT create_date 
FROM customer

+-------------+
| create_date |
|-------------|
| 2006-02-14  |
+-------------+

Types de données INTERVAL

+-----------+
| interval  |
|-----------|
| 4 days    |
+-----------+


SELECT rental_date + INTERVAL '3 days' as expected_return
FROM rental;


+---------------------+
| expected_return     |
|---------------------|
| 2005-05-27 22:53:30 |
+---------------------+

Analyse des types de date et d'heure

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 |
+-------------+-----------------------------+

Passons à la pratique !

Fonctions permettant de manipuler les données dans PostgreSQL