# DATE\_TRUNC

지정된 시간 단위로 날짜를 절삭합니다.

## 문법

```
DATE_TRUNC(unit, time)
```

## 인수

| 이름 | 유형 | 설명 | 기본값 |
| --- | --- | --- | --- |
| 단위 | 문자열 |  |  |
| 시간 | 타임스탬프 |  |  |

## 를 반환합니다.

타임스탬프

***

## 예

| 단위 | 시간 | 출력 |
| --- | --- | --- |
| "밀리초" | 타임스탬프 "2021-02-03 04:05:06.789" | 타임스탬프 "2021-02-03 04:05:06.789" |
| "초" | 타임스탬프 "2021-02-03 04:05:06.789" | 타임스탬프 "2021-02-03 04:05:06" |
| "분" | 타임스탬프 "2021-02-03 04:05:06.789" | 타임스탬프 "2021-02-03 04:05:00" |
| "시간" | 타임스탬프 "2021-02-03 04:05:06.789" | 타임스탬프 "2021-02-03 04:00:00" |
| "일" | 타임스탬프 "2021-02-03 04:05:06.789" | 타임스탬프 "2021-02-03 00:00:00" |
| "주" | 타임스탬프 "2021-02-03 04:05:06.789" | 타임스탬프 "2021-02-01 00:00:00" |
| "월" | 타임스탬프 "2021-02-03 04:05:06.789" | 타임스탬프 "2021-02-01 00:00:00" |
| "분기" | 타임스탬프 "2021-02-03 04:05:06.789" | 타임스탬프 "2021-01-01 00:00:00" |
| "년" | 타임스탬프 "2021-02-03 04:05:06.789" | 타임스탬프 "2021-01-01 00:00:00" |
| "밀리초" | 타임스탬프 "2021-12-31 23:59:59.999" | 타임스탬프 "2021-12-31 23:59:59.999" |
| "초" | 타임스탬프 "2021-12-31 23:59:59.999" | 타임스탬프 "2021-12-31 23:59:59" |
| "분" | 타임스탬프 "2021-12-31 23:59:59.999" | 타임스탬프 "2021-12-31 23:59:00" |
| "시간" | 타임스탬프 "2021-12-31 23:59:59.999" | 타임스탬프 "2021-12-31 23:00:00" |
| "일" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-12-31 00:00:00" |
| "주" | timestamp "2021-12-31 23:59:59.999" | 타임스탬프 "2021-12-27 00:00:00" |
| "월" | 타임스탬프 "2021-12-31 23:59:59.999" | 타임스탬프 "2021-12-01 00:00:00" |
| "분기" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-10-01 00:00:00" |
| "년" | timestamp "2021-12-31 23:59:59.999" | timestamp "2021-01-01 00:00:00" |
| "테스트" | 타임스탬프 "2021-12-31 23:59:59.999" | null |