[PostgreSQL] 날짜 관련 상황별 정리

1. SELECT

 

1-1. 타임스탬프를 문자로 (SELECT Timestamp To String)

SELECT to_char(created_at, 'YYYY-MM-DD') AS date_str FROM users;

 

2. WHERE

 

2-1. 타임스탬프 (WHERE Timestamp to Date)

 

2-1-1. 첫번째 방법 ( :: cast )

SELECT * FROM users WHERE  created_at::date >= '2022-09-01'

 

2-1-2. 두번째 방법 ( function cast )

SELECT * FROM users WHERE  CAST ( created_at AS date) >= '2022-09-01'