HOUR

์ง€์ •๋œ ๋‚ ์งœ์˜ ์‹œ๊ฐ„ ๊ตฌ์„ฑ์š”์†Œ๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

์‚ฌ์šฉ ์˜ˆ์‹œ

HOUR(Date)

๊ตฌ๋ฌธ

๋‹ค์Œ ๊ตฌ๋ฌธ์€ ๋‚ ์งœ ๋ฐ ์‹œ๊ฐ„ ๊ฐ’์—์„œ ์‹œ๊ฐ„์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

HOUR( date_expression )

๋‹ค์Œ ๊ตฌ๋ฌธ์€ ํ˜ธํ™˜์„ฑ ๋ชจ๋“œ ๋‚ ์งœ ๊ฐ’์—์„œ ์‹œ๊ฐ„์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

HOUR( X [, format_string ])

๋งค๊ฐœ๋ณ€์ˆ˜

  • date_expression - ๋‚ ์งœ ๋ฐ ์‹œ๊ฐ„ ํ•„๋“œ ๋˜๋Š” ํ‘œํ˜„์‹
  • X - ํ…์ŠคํŠธ, ์ˆซ์ž ๋˜๋Š” ํ˜ธํ™˜์„ฑ ๋ชจ๋“œ ๋‚ ์งœ๋กœ ํ‰๊ฐ€๋˜๋Š” ํ•„๋“œ ๋˜๋Š” ํ‘œํ˜„์‹
  • format_string: X.์˜ ํ˜•์‹์ž…๋‹ˆ๋‹ค. X๊ฐ€ ์˜๋ฏธ์  ๋‚ ์งœ ํ•„๋“œ๋กœ ์˜ฌ๋ฐ”๋ฅด๊ฒŒ ๊ตฌ์„ฑ๋œ ๊ฒฝ์šฐ ์„ ํƒ์‚ฌํ•ญ์ž…๋‹ˆ๋‹ค.

ํ˜ธํ™˜์„ฑ ๋ชจ๋“œ ๋‚ ์งœ์˜ ํ˜•์‹ ๋ฌธ์ž์—ด

X๊ฐ€ ํ…์ŠคํŠธ ํ•„๋“œ ๋˜๋Š” ํ‘œํ˜„์‹์ด๋‚˜ ํ˜ธํ™˜์„ฑ ๋ชจ๋“œ ๋‚ ์งœ์ธ ๊ฒฝ์šฐ ๋‹ค์Œ๊ณผ ๊ฐ™์€ ํ˜•์‹์˜ ์ง€์›๋˜๋Š” ๋‚ ์งœ ํ•จ์ˆ˜ ์ž…๋ ฅ์ด ํ—ˆ์šฉ๋ฉ๋‹ˆ๋‹ค.

  • BASIC: %Y/%m/%d-%H:%M:%S
  • DEFAULT_DASH: %Y-%m-%d [%H:%M:%S]
  • DEFAULT_SLASH: %Y/%m/%d [%H:%M:%S]
  • DEFAULT_DECIMAL: %Y%m%d [%H:%M:%S]
  • RFC_1123: ์˜ˆ๋ฅผ ๋“ค๋ฉด Sat, 24 May 2008 20:09:47 GMT์ž…๋‹ˆ๋‹ค.
  • RFC_3339: ์˜ˆ: 2008-05-24T20:09:47Z
  • DECIMAL_DATE: DEFAULT_DECIMAL๊ณผ ๋™์ผ

์œ ํšจํ•œ strptime ํ˜•์‹์€ ๋ชจ๋‘ ํ—ˆ์šฉ๋ฉ๋‹ˆ๋‹ค.

X๊ฐ€ ์ˆซ์ž ํ•„๋“œ ๋˜๋Š” ํ‘œํ˜„์‹์ธ ๊ฒฝ์šฐ ๋‹ค์Œ๊ณผ ๊ฐ™์€ ํ˜•์‹์˜ ์ง€์›๋˜๋Š” ์‹œ๊ฐ„ ํ•จ์ˆ˜ ์ž…๋ ฅ์ด ํ—ˆ์šฉ๋ฉ๋‹ˆ๋‹ค.

  • SECONDS: ์—ํฌํฌ ์ดํ›„ ๊ฒฝ๊ณผ ์‹œ๊ฐ„(์ดˆ)
  • MILLIS: ์—ํฌํฌ ์ดํ›„ ๊ฒฝ๊ณผ ์‹œ๊ฐ„(๋ฐ€๋ฆฌ์ดˆ)
  • MICROS: ์—ํฌํฌ ์ดํ›„ ๊ฒฝ๊ณผ ์‹œ๊ฐ„(๋งˆ์ดํฌ๋กœ์ดˆ)
  • NANOS: ์—ํฌํฌ ์ดํ›„ ๊ฒฝ๊ณผ ์‹œ๊ฐ„(๋‚˜๋…ธ์ดˆ)
  • JULIAN_DATE: ์—ํฌํฌ ์ดํ›„ ๊ฒฝ๊ณผ ์ผ์ˆ˜

์˜ˆ์‹œ

์ˆ˜์‹ ์˜ˆ ์ž…๋ ฅ ์ถœ๋ ฅ
HOUR(Date) Jan 1, 2019 0
HOUR(Date as Text, 'BASIC') 2019/01/01-09:40:45 9
HOUR(Date as Number, 'SECONDS') 1561784874 5

HOUR(Date as lots of Numbers, 'MILLIS')

1562004058620 18

์ฐธ๊ณ 

์ด ํ•จ์ˆ˜๋Š” ํ˜ธํ™˜์„ฑ ๋ชจ๋“œ ๋‚ ์งœ ๋ฐ ์—…๊ทธ๋ ˆ์ด๋“œ๋œ ๋‚ ์งœ์™€ ๋‚ ์งœ ๋ฐ ์‹œ๊ฐ„ ๋ฐ์ดํ„ฐ ์œ ํ˜• ๋ชจ๋‘์—์„œ ์ž‘๋™ํ•ฉ๋‹ˆ๋‹ค.