Keyboard shortcuts

Press ← or → to navigate between chapters

Press ? to show this help

Press Esc to hide this help

타임스탬프 수열

항목값
화면 이름Timestamp sequence
식별자timestampSequenceV1
지원 실행 방식Batch, Faster
범주날짜와 시간 (Datetime)
반환 자료형Array<Timestamp>

시작값부터 끝값 범위의 타임스탬프 배열을 만듭니다.

입력 인자

이름지정 여부자료형의미와 조건
End time필수Expression<Date | Timestamp>범위의 끝 타임스탬프이며 경계값을 포함합니다.
Start time필수Expression<Date | Timestamp>범위의 시작 타임스탬프이며 경계값을 포함합니다.
Step unit필수Enum<Days, Hours, Milliseconds, Minutes, Seconds, Weeks>단계 크기의 단위입니다.
Step size선택Expression<Numeric>인접 값 사이의 단계 크기입니다. 기본값은 1입니다.

입출력 예시

예시 1: 기본 동작

인자 값:

  • End time: end_time
  • Start time: start_time
  • Step unit: DAYS
  • Step size: 1.0
start_timeend_time출력
2023-01-01T00:00:00Z2023-01-03T00:00:00Z[ 2023-01-01T00:00:00Z, 2023-01-02T00:00:00Z, 2023-01-03T00:00:00Z ]
2023-01-01T01:50:00Z2023-01-03T00:00:00Z[ 2023-01-01T01:50:00Z, 2023-01-02T01:50:00Z ]

예시 2: 기본 동작

인자 값:

  • End time: end_time
  • Start time: start_time
  • Step unit: DAYS
  • Step size: 1
start_timeend_time출력
2023-01-012023-01-03[ 2023-01-01T00:00:00Z, 2023-01-02T00:00:00Z, 2023-01-03T00:00:00Z ]

예시 3: 기본 동작

인자 값:

  • End time: end_time
  • Start time: start_time
  • Step unit: DAYS
  • Step size: 1.0
start_timeend_time출력
2023-01-03T00:00:00Z2023-01-01T00:00:00Z[ 2023-01-03T00:00:00Z, 2023-01-02T00:00:00Z, 2023-01-01T00:00:00Z ]
2023-01-03T00:00:00Z2023-01-01T01:50:00Z[ 2023-01-03T00:00:00Z, 2023-01-02T00:00:00Z ]

예시 4: null 처리

인자 값:

  • End time: end_time
  • Start time: start_time
  • Step unit: DAYS
  • Step size: 1.0
start_timeend_time출력
null2023-01-01T00:00:00Znull
nullnullnull

예시 5: null 처리

인자 값:

  • End time: end_time
  • Start time: start_time
  • Step unit: DAYS
  • Step size: null
start_timeend_time출력
2023-01-03T00:00:00Z2023-01-01T00:00:00Znull
2023-01-01T01:50:00Z2023-01-03T00:00:00Znull

예시 6: null 처리

인자 값:

  • End time: end_time
  • Start time: start_time
  • Step unit: DAYS
  • Step size: step
start_timeend_timestep출력
2023-01-03T00:00:00Z2023-01-01T00:00:00Z0.0null

예시 7: 경계 조건

인자 값:

  • End time: end_time
  • Start time: start_time
  • Step unit: DAYS
  • Step size: null
start_timeend_time출력
2023-01-03T00:00:00Z2023-01-01T00:00:00Z[ 2023-01-03T00:00:00Z, 2023-01-02T00:00:00Z, 2023-01-01T00:00:00Z ]
2023-01-01T01:50:00Z2023-01-03T00:00:00Z[ 2023-01-01T01:50:00Z, 2023-01-02T01:50:00Z ]

예시 8: 경계 조건

인자 값:

  • End time: end_time
  • Start time: start_time
  • Step unit: DAYS
  • Step size: null
start_timeend_time출력
2023-01-03T00:00:00Z2023-01-03T00:00:00Z[ 2023-01-03T00:00:00Z ]