[PostgreSQL] DATE / TIME 다루기

CURRENT_TIMESTAMP는 표준 SQL / NOW()는 비표준SQL이다. (결과는 동일하다.)

NOW()

SELECT NOW()

2021-09-02 11:21:39.028994+09

CURRENT_TIMESTAMP

SELECT CURRENT_TIMESTAMP

2021-09-02 11:21:39.028994+09

CURRENT_DATE

SELECT CURRENT_DATE

2021-09-02

 

 

 

https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT

9.9. Date/Time Functions and Operators