티스토리 뷰

DB

[PostgreSQL] DATE / TIME 다루기

나뜨루다 2021. 9. 2. 11:28
728x90

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

9.9. Date/Time Functions and Operators 9.9.1. EXTRACT, date_part 9.9.2. date_trunc 9.9.3. AT TIME ZONE 9.9.4. Current Date/Time 9.9.5. Delaying Execution Table 9.32 …

www.postgresql.org

 

저작자표시

'DB' 카테고리의 다른 글

[MyBatis] LIKE 검색 구문 (Oracle, PostgreSQL, MySQL, Mssql)  (0) 2021.12.28
[PostgreSQL]Error updating database. Cause: org.postgresql.util.PSQLException: 오류: 릴레이션(relation) 접근 권한 없음  (0) 2021.10.08
[Mybatis] The content of elements must consist of well-formed character data or markup (<![CDATA ]]> , &lt;) 사용하기  (0) 2021.07.09
[SQL] where절 1=0 (false) 사용예제  (0) 2021.07.09
[Oracle] 다중 LIKE OR / REGEXP_LIKE // IN  (2) 2021.06.29